search

ivylabs / suitecrm-data-integration

7 stars 5 forks source link

Create Activities Fact Solution #117

Closed harrisward closed 3 years ago

harrisward commented 3 years ago

We need to add the ability for end users to analyse activity facts for calls, emails and meetings.

This solution will include at least three transformations:

One transformation to populate the S_ACTIVITIES staging table One transformation to populate the D_ACTIVITIES dimension One transformation to populate the F_ACTIVITIES fact

The solution also needs CREATE TABLE DDLs for each staging, dimension and fact table

The dimension needs priming DDL also

Refer to the table documentation here:

https://ivy-is.atlassian.net/wiki/spaces/CRM/pages/1666842625/F+ACTIVITIES https://ivy-is.atlassian.net/wiki/spaces/CRM/pages/1667104801/D+ACTIVITIES

harrisward commented 3 years ago

Initial Testing done and merged into master