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 can we run the graph? How can we schedule the graph in unix?
Why denormalization is promoted in universe designing?
How are models actually derived?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
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?
What are the different types of fact tables used in data warehousing?
What is meta data and system catalog?
Explain what is the extension of file to save template?
For faster process, what we will do with the universe?
What is surrogate key? Explain with examples.
What are the advantages of raid 1, 1/0, and
What are diagrams?
Explain the data type of the surrogate key?
What is meant by metadata in context of a data warehouse and how it is important?
How to improve session performance in aggregator transformation?