|
INTERVIEW QUESTIONS
DATA WAREHOUSING
GENERAL DATAWAREHOUSING
DETAILS
Question: What is ODS?
Answer: 1. ODS means Operational Data Store.
Submitted by Francis C. ( xxchen74 @ hotmail . com )
2. A collection of operation or bases data that is extracted from operation databases and standardized, cleansed, consolidated, transformed, and loaded into an enterprise data architecture. An ODS is used to support data mining of operational data, or as the store for base data that is summarized for a data warehouse. The ODS may also be used to audit the data warehouse to assure summarized and derived data is calculated properly. The ODS may further become the enterprise shared operational database, allowing operational systems that are being reengineered to use the ODS as there operation databases.
( Submitted by Amit Mathur )
|
|
|
Category |
General Datawarehousing Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9898 users |
Added on |
12/5/2009 |
Views |
80309 |
Rate it! |
|
|
Question:
What is ODS?
Answer:
1. ODS means Operational Data Store.
Submitted by Francis C. ( xxchen74 @ hotmail . com )
2. A collection of operation or bases data that is extracted from operation databases and standardized, cleansed, consolidated, transformed, and loaded into an enterprise data architecture. An ODS is used to support data mining of operational data, or as the store for base data that is summarized for a data warehouse. The ODS may also be used to audit the data warehouse to assure summarized and derived data is calculated properly. The ODS may further become the enterprise shared operational database, allowing operational systems that are being reengineered to use the ODS as there operation databases.
( Submitted by Amit Mathur ) Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What type of Indexing mechanism do we need to use for a typical datawarehouse?
|
View Answer
|
|
Which columns go to the fact table and which columns go the dimension table?
|
View Answer
|
|
What is a level of Granularity of a fact table?
|
View Answer
|
|
What does level of Granularity of a fact table signify?
|
View Answer
|
|
How are the Dimension tables designed?
|
View Answer
|
|
What are slowly changing dimensions?
|
View Answer
|
|
What are non-additive facts?
|
View Answer
|
|
What are conformed dimensions?
|
View Answer
|
|
What is VLDB?
|
View Answer
|
|
What is SCD1 , SCD2 , SCD3?
|
View Answer
|
|
What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
|
View Answer
|
|
What are conformed dimensions?
|
View Answer
|
|
Differences between star and snowflake schemas?
|
View Answer
|
|
How do you load the time dimension?
|
View Answer
|
|
Why are OLTP database designs not generally a good idea for a Data Warehouse?
|
View Answer
|
|
Why should you put your data warehouse on a different system than your OLTP system?
|
View Answer
|
|
Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All General Datawarehousing Interview Questions & Answers - Exam Mode /
Learning Mode
|