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
Explain what is a view as it relates to system modeling?
Explain what are components of report studio?
What is static and local variable?
What are the design methods of data warehousing?
Explain which are the olap tools available that are supported by oracle?
What are the data marts?
What is the use of dimensional modeling in data warehousing?
What should I have in mind when building olap solution from scratch?
What are the approaches used by optimizer during execution plan?
Explain the difference between dw and bi?
What is difference between query studio and report studio?
Explain reference cursor?
Can we take backup when the database is opened?
What is called data cleaning?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?