Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between ODS and Staging
- 4 Answers
- 40586 Views
- HeadStrong, TCS, I also Faced
- E-Mail Answers
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 multivalued dependency?
What are Aggregate tables?
Can a dimension table contain numeric values?
How many project sources we can create in metadata?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What are the different types of datawarehosuing?
Explain datawarehousing?
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 is real-time datawarehousing?
How to load the time dimension?
What is data warehouse architecture?
Explain what is the difference between stop and abort?
What are aggregate transformation?
Explain what is analytical or analytic mean?
Explain the difference between filter and conditin?
