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

Explain what is a view as it relates to system modeling?

574


Explain what are components of report studio?

570


What is static and local variable?

563


What are the design methods of data warehousing?

515


Explain which are the olap tools available that are supported by oracle?

553






What are the data marts?

526


What is the use of dimensional modeling in data warehousing?

542


What should I have in mind when building olap solution from scratch?

539


What are the approaches used by optimizer during execution plan?

490


Explain the difference between dw and bi?

519


What is difference between query studio and report studio?

532


Explain reference cursor?

1700


Can we take backup when the database is opened?

594


What is called data cleaning?

621


If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

520