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
What is aggregate fact table?
Define data warehouse?
What is VLDB?
How can we schedule the graph in unix?
What are the different ways to represent the loading of dimension tables?
Explain some of modeling tools available in the market?
Explain vldb?
What is crass reference table?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain what is analytical or analytic mean?
Where we use surrogate key explain with example?
Can we start and stop single session in concurent bstch?
What are various warehousing tools?
What is the difference between ods and oltp?
How do you define data block size?