GeekInterview.com
Series: Subject: Topic:
Question: 9 of 726

what is staging are why we need it

Asked by: kishore sai | Member Since Aug-2012 | Asked on: Aug 3rd, 2012

View all questions by kishore sai

Showing Answers 1 - 1 of 1 Answers
MAHESH MANAM

Answered On : Aug 16th, 2012

It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and performing quality checks while building the data warehouse.
It typically accounts for 70-80% of the effort in a data warehousing initiative.

If you store data in data warehouse directly it is very difficult to retrieve data from that because various types of database are going to store in warehouse.

So for better performance we are going to store data in staging in common format.

  
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

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

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.