Difference between ODS and Staging
Answer Posted / kalpana
1. ODS is close to the source. We can say it is a replica
of source system.
While the staging area is a replica of the target DW.
2. The dimention and fact will come into picture here in
staging.
3. We are doing the Transformations in staging schema
before loading it to the target.
4. We integrate different ODS source systems into the
staging area and not in the ODS.
Is This Answer Correct ? | 17 Yes | 21 No |
Post New Answer View All Answers
What are the reasons to use a chameleon method in data warehousing?
How to create context?
Who needs data warehousing?
What is the function of surrogate key in data warehousing?
Is there any rownum object from which we can do this?
What is freehand sql?
What are fundamental stages of data warehousing?
What are the different types of datawarehosuing?
What is the difference between Datawarehouse and OLAP?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What are Non-additive facts?
List down some of the real time data-warehousing tools?
What are the advantages and disadvantages of reporting directly against the database?
Explain how are the dimension tables designed?
What is the difference between ods and oltp?