All tables must be in DM
2 posters
Page 1 of 1
All tables must be in DM
Hello,
Suppose we have to migrate a relational database to a dimensional model. We have to ensure that all the columns of all tables in the relational database are present in the target DM. What do you suggest to do if a table does not fit in any star?
regards,
Suppose we have to migrate a relational database to a dimensional model. We have to ensure that all the columns of all tables in the relational database are present in the target DM. What do you suggest to do if a table does not fit in any star?
regards,
rf001- Posts : 23
Join date : 2010-12-16
Re: All tables must be in DM
The purpose of a data warehouse is not to keep stuff around forever, that is what backups are for. It is for performing analytics. You don't need to bring in everything.
Re: All tables must be in DM
I am thinking on a bit different lines:
Normalization makes a database model very complex to understand. Lets say an organization wants to migrate its relational database to dimensional modeling for the sake of making it simple to understand and easy to access in the future. Future users may query it only after figuring out the fact tables.
Do you think it is worthy to do? If yes, what are the things to be careful of?
thanks for such a prompt response.
Normalization makes a database model very complex to understand. Lets say an organization wants to migrate its relational database to dimensional modeling for the sake of making it simple to understand and easy to access in the future. Future users may query it only after figuring out the fact tables.
Do you think it is worthy to do? If yes, what are the things to be careful of?
thanks for such a prompt response.
rf001- Posts : 23
Join date : 2010-12-16
Similar topics
» Storing Date Keys in dimension tables versus fact tables
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Number of Columns in Fact Tables vs. Dimension Tables
» Should this really be two different fact tables and not one?
» Many to many between fact tables
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Number of Columns in Fact Tables vs. Dimension Tables
» Should this really be two different fact tables and not one?
» Many to many between fact tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum