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
Explain what is partitioning? What are the types of partitioning?
Explain what are components of report studio?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What are data modeling and data mining?
What is data stream and data adaopter. Is it same are different? Explain?
Explain what is a three tier data warehouse?
What are the different types of segments?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Explain difference between e-r modeling and dimentional modeling?
How can we schedule the graph in unix?
What is the purpose of Dataware Control?
Define data warehouse?
Explain the data type of the surrogate key?
What are the advantages and disadvantages of reporting directly against the database?
Explain what is fact less fact table? Where you have used it in your project?