Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between ODS and Staging
- 4 Answers
- 40592 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
What are data validation strategies for data mart validation after loading process?
After the complete generation of a report who will test the report and who will analyze it?
List any five applications of data warehouse.
Explain er diagram?
What are the different types of datawarehosuing?
How to handle multi value dimensions?
What is a hash cluster?
Explain what are the modules in power mart?
what are relationships?
What is difference macros and prompts?
Can we start and stop single session in concurent bstch?
What are partition points?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Where we use surrogate key explain with example?
How can you clear the cache?
