Difference between ODS and Staging
Answer Posted / pravin
Operational Data store is a subject
oriented,integrated,current,volatile collection of data
used to support the tactical decision making process for
the enterprise. It is the central point of data integration
for busienss management,delivering a common view of
enterprise data.
In Staging Area you are carried out ETL operations as per
your business logic in order to fetch processed information
into data ware house.
Is This Answer Correct ? | 9 Yes | 12 No |
Post New Answer View All Answers
How to test report in reportnet?
What is dimension modeling?
Explain dimensional modelling?
Is union transormation is active transformation?
What are situations where snowflake schema is better than star schema when the opposite is true?
Where the data cube technology is used?
Explain degenerate dimension table?
Which are the olap tools available that are supported by oracle?
What are aggregate tables and aggregate fact tables?
What is the difference between filter and lookup transformation?
What is an er diagram?
Explain some of modeling tools available in the market?
Explain what is metadata reporter?
For faster process, what we will do with the universe?
Is there any rownum object from which we can do this?