Hierarchy of DWH?
- 2 Answers
- 17805 Views
- Accenture, EDS, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 9885657928
1.Source
2.Exteact
3.Tranform
4.Load
5.Taget
| Is This Answer Correct ? | 21 Yes | 3 No |
What is the goal of optimizer?
What are the stages of datawarehousing?
What is multi-dimensional analysis?
What is operational data store (ods)?
Give some difference between oltp and olap.
What is many-to-many dimensional model in datawarehousing ?
How to performance tune reports?
State any 5 of Cods guidelines of an OLAP system, brief description each?
Suppose we want to display zero when null values coming to report how can we do that?
Explain me what is vldb?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Teradata 
