Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between ODS and Staging
- 4 Answers
- 40569 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
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
How many project sources we can create in metadata?
What is called dimensional modelling?
what is parallel query?
What are the types of SCD?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
How did you plan your Data ware house project?
What is your spectra photometer working principles?
What is the function of etl when used in data warehousing?
Explain why dimenstion tables are denormalized in nature?
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 meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is scd1 , scd2 , scd3?
What is VLDB?
What are the differences between datamart vs. Reporting cube?
What is a view as it relates to system modeling?
