Series: Subject: Topic:
Question: 31 of 135

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 ?
Asked by: jryan999 | Member Since Apr-2008 | Asked on: Apr 30th, 2008

View all questions by jryan999   View all answers by jryan999

Showing Answers 1 - 1 of 1 Answers

Answered On : Dec 16th, 2008

View all answers by mri_sonam

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.

Login to rate this answer.

Give your answer:

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

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.