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 can we run the graph? How can we schedule the graph in unix?

492


Why denormalization is promoted in universe designing?

545


How are models actually derived?

1513


What are situations where snow flake schema is better than star schema to use and when the opposite is true?

524


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

563






What are the different types of fact tables used in data warehousing?

550


What is meta data and system catalog?

1844


Explain what is the extension of file to save template?

503


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

559


What is surrogate key? Explain with examples.

597


What are the advantages of raid 1, 1/0, and

520


What are diagrams?

613


Explain the data type of the surrogate key?

556


What is meant by metadata in context of a data warehouse and how it is important?

646


How to improve session performance in aggregator transformation?

520