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
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Why fact table is in a normal form?
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain how are the dimension tables designed?
What is the difference between connected and unconnected stored procedures?
What we will do with the universe for faster process?
What is the difference between drill through and masterdetail reports?
How to improve session performance in aggregator transformation?
How to limit the max no of rows retrieved in the report?
What is called dimensional modelling?
What are universe requirements?
what is difference between drill & scope of analysis?
What are the mapping paramaters and maping variables?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are templates in which way it is help full?