Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
1132Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
928Post New Data Warehouse General Questions
What is perform recovery?
Explain dimensional modelling?
How to limit the max no of rows retrieved in the report?
Explain conformed fact?
Why fact table is in a normal form?
what are relationships?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain the different types of data warehousing?
Explain is fact table?
Compare aggregates and data marts
What is a source qualifier?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Where the data cube technology is used?
What is fact less fact table? Where you have used it in your project?
What are the types of SCD?