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
I have two universes created by two difference database can we join them in designer & report level? How
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is conformed fact?
What are partition points?
Can we start and stop single session in concurent bstch?
Explain what are the modules in power mart?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What is the data type of the surrogate key?
What is Active Datawarehousing?
What are aggregate transformation?
Explain how to export mappings to the production environment?
Explain what is a three tier data warehouse?
Explain meta data?
Explain a relation schema and a relation?
What is your spectra photometer working principles?