Hierarchy of DWH?
Answer Posted / sivakumar
Data modeling
ETL process
BI process
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What are aggregate tables and aggregate fact tables?
Explain the difference between keylokup and joiner?
Explain what is the difference between view filter and report filter?
What is dimension modeling?
What is static and local variable?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Explain a relation schema and a relation?
Which are the olap tools available that are supported by oracle?
What is surrogate key? Where we use it explain with example?
What is the difference between Datawarehouse and OLAP?
What are modeling tools available in the market?
Explain what are fact, dimension, and measure?
How to add a number to a macro variable?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?