Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
1206Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
977Post New Data Warehouse General Questions
What is the main difference between schema in rdbms and schemas in datawarehouse?
What is is a star schema?
What is dimensional modelling?
How to generate the cubes in framework manager?
List down some of the real time data-warehousing tools?
Explain what are slowly changing dimensions?
Explain what is the difference between a primary and secondary actor in use case modeling?
What is incremintal loading?
Difference between e-r modeling and dimentional modeling?
Explain reference cursor?
What are the steps involved in designing a fact table?
How to create context?
Explain the main differences between star and snowflake schema?
What is a full backup?
What are the other names given to data warehousing?