Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between ODS and Staging
- 4 Answers
- 40749 Views
- HeadStrong, TCS, I also Faced
- E-Mail Answers
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 are the different types of data warehousing?
What is the difference between view filter and report filter?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is the purpose of cluster analysis in data warehousing?
How to pivot row data using informatica?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain a mapping, session, worklet, workflow, mapplet?
What is Discrete and Continuous data in Data mining world?
What function should we use to display the value entered or selected by a user in response to a prompt?
What are Non-additive facts?
Explain swot analysis?
What is incremintal loading?
Explain dimensional modelling?
Explain what is the difference between stop and abort?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
