Explain the definition of normalized and denormalized view and what are the differences between them?
514What are situations where snow flake schema is better than star schema to use and when the opposite is true?
526Post New Data Warehouse General Questions
List any five applications of data warehouse.
Explain about core dimension, balanced dimension, and dirty dimension?
What are diagrams?
Explain the different types of data warehousing?
What are the main steps to build the data warehouse?
How to join 3 database like flat file, oracle, db2 in informatrica?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain what is a three tier data warehouse?
What is vdl (view definition language) explain?
Explain dimension table ?
Explain how to export mappings to the production environment?
What is drill-through?
What should I have in mind when building olap solution from scratch?
The same tier?
what are the other factors of the database on which the loading performance depend?
