Answer Posted / samir kumar sahoo
It is a collection of integrated databases designed to
support operational monitoring. Unlike the OLTP databases
the data in the ODS are integrated, subject oriented and
enterprise wide data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain difference between data ware house & data mart?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Explain what is the data type of the surrogate key?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Explain is fact table?
Store (and count) non-fact records?
What are the mapping paramaters and maping variables?
How to create different types of templates?
What is a relationship?
Define Data Warehousing?
What are the different types of schemas used in data warehousing?
Explain why fact table is in normal form?
What are parallel querys and query hints?
Explain what are necessary tasks to install reportnet software?