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
Can any one explain the hierarchies level data warehousing.
What are the different types of join operations?
What are the stages that are required in data warehousing?
Explain what is batch and describe about types of batches?
Explain can a dimension table contains numeric values?
what are the others of "bad files" and "discard files" when using sql*loader?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is core dimension?
Explain multivalued dependency?
What are the advantages of query studio compared to report studio?
What are the reasons to use a chameleon method in data warehousing?
Why null values are mapped as 0 in fact tables?
What is called dimensional modelling?
What is difference between query studio and report studio?
What are the advantages of cold fusion?