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


Please Help Members By Posting Answers For Below Questions

How to test report in reportnet?

566


What is dimension modeling?

533


Explain dimensional modelling?

544


Is union transormation is active transformation?

588


What are situations where snowflake schema is better than star schema when the opposite is true?

562






Where the data cube technology is used?

546


Explain degenerate dimension table?

542


Which are the olap tools available that are supported by oracle?

521


What are aggregate tables and aggregate fact tables?

526


What is the difference between filter and lookup transformation?

614


What is an er diagram?

636


Explain some of modeling tools available in the market?

524


Explain what is metadata reporter?

569


For faster process, what we will do with the universe?

571


Is there any rownum object from which we can do this?

522