Maintain Dimensions - ETL or Data Entry

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 ?

Questions by jryan999   answers by jryan999

Showing Answers 1 - 1 of 1 Answers


  • Dec 16th, 2008

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions