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 are slowly changing dimensions?
What function should we use to display the value entered or selected by a user in response to a prompt?
How to define a cube??
Which columns go to the fact table and which columns go the dimension table?
Explain why should you put your data warehouse on a different system than your oltp system?
Explain why fact table is in normal form?
What is hybrid slowly changing dimension?
What are the stages of datawarehousing?
Explain the difference between view and materialized view?
Can you brief about the Data warehouse project you worked on?
Difference between PowerPlay transformer and power play reports?
Explain vldb?
How we are using this function?
What is execution plan?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?