I have created a DW DB which has dimension like
USERS -- user_id as PK
ADDRESS --address_id as PK
TIME --date_key as PK
Role dimensions like Deposit Date
And fact tables
Profit
Deposit Withdrawal
Both the dimensions are subject to change say every minute and so are the fact tables. The database has huge amount of data ie., both fact tables have billions of records I want to process the cube so that the users receive the most up to date data.
I have added aggregations and partitions which have improved the performance of the cube.
How can I deal with the slow changing dimensions in this case??
And what are the best practices that I can apply for the performance improvement in this case?
How do I automate the cube processing?
Do I need to create SSIS packages which begin with updating the dimension tables and fact tables followed by processing them and them processing the partitions?
I need all the suggestion from you experts I am new to DW and this is my first project
Start Free Trial
