What is staging area?

Answer Posted / harish

Its an intermidiate stage where data is put before its put
into the Datawarehouse database.It is also called
Operational Data Source(ODS).If a report is needed very
urgently though its not a nice one to have then we can
generate from the staging area or ODS.

Ex: if i am so hungry that i cannot wait until my food is
cooked i can have it though it does not taste good.but
because i am too hungry i would not mind that taste.later
once its cooked i can enjoy it much better.


that was just to give an understanding of the concept.

any one please correct me if i am wrong.
Regards,
HARISH.

Is This Answer Correct ?    8 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are steps we have to follow in designing the userfriendly universe?

558


How are the dimension tables designed?

571


What are the mapping paramaters and maping variables?

571


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

1719


What are the other names given to data warehousing?

646






What is difference macros and prompts?

1715


Explain what is the difference between datawarehouse and bi?

531


Explain what are slowly changing dimensions?

613


Define data warehouse?

556


Do you view contain data?

563


How to design file watch jobs?

585


What is data cleaning? How can we do that?

567


Explain what are fact, dimension, and measure?

562


Explain the importance of data warehouse?

573


Explain the main difference between inmon and kimball philosophies of data warehousing?

556