Difference between ODS and Staging
Answer Posted / sunil
ODS means operational data store which supports operational
monitoring,data is
volatile,current,detailed,subjectoriented and integrated.
Staging is temperary storage location which is used for
processing the data.
staging area cleans operational data before loading the
data into Dw.
Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How to pivot row data using informatica?
Explain a linked cube?
What is bi?
What are Aggregate tables?
explain about dirty dimension?
What are the different types of datawarehosuing?
What is the metadata extension?
Explain about core dimension,
Can you state some of the innovations throughout history?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
How to improve session performance in aggregator transformation?
How can we do data cleaning?
Code the tables statement for a single-level (most common) frequency?
What is edw?