Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

All tables must be in DM

2 posters

Go down

All tables must be in DM Empty All tables must be in DM

Post  rf001 Sat Jun 16, 2012 9:23 pm

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,
rf001
rf001

Posts : 23
Join date : 2010-12-16

Back to top Go down

All tables must be in DM Empty Re: All tables must be in DM

Post  ngalemmo Sun Jun 17, 2012 6:36 pm

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.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

All tables must be in DM Empty Re: All tables must be in DM

Post  rf001 Sun Jun 17, 2012 7:14 pm

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.
rf001
rf001

Posts : 23
Join date : 2010-12-16

Back to top Go down

All tables must be in DM Empty Re: All tables must be in DM

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum