| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: Maintain Dimensions - ETL or Data Entry
Answer: For a Customer or Product Dimension with 500,000 rows changing daily an ETL solution is the only sensible way forward. But surely you shouldn't ETL every single Dimension table - especially if there's over a hundred of them, and they're are static, error prone or manually enhanced?
What would you advise / normally do ? |
| December 12, 2008 21:56:19 |
#1 |
| mri_sonam |
Member Since: July 2008 Total Comments: 15 |
RE: Maintain Dimensions - ETL or Data Entry
|
If you are designing a Data Warehouse how can you rely on manual process? better way is to use ETL wherever required or else just extract and load.
But you should refresh all your dimensions regularly and not manually.
better to check for the changed data and then do the extract; if your dimensions are mostly static. |
| |
Back To Question | |
