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
Why facts table is useful in representing the data?
Explain what are non-additive facts in detail?
What is data analysis?
What is data type of the surrogate key?
Explain conformed fact?
What are the different types of data warehousing?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain what is a view as it relates to system modeling?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is the very basic difference between data warehouse and operational databases?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
How to define a cube??
What are steps we have to follow in designing the userfriendly universe?
Explain what are the possible data marts in retail sales?