What is Denormalization? - ETL

ETL (extract, transform, and load) Testing Interview Questions

(Continued from previous question...)

60. What is Denormalization? - ETL

Denormalization means a table with multi duplicate key. The dimension table follows Denormalization method with the technique of surrogate key.

(Continued on next question...)

Other Interview Questions

• What is the difference between Data Mining and Data Warehousing? - ETL
• What does the Bottom Up Approach or Ralph Kimball Approach says? - ETL
• What is a Data Warehouse? - ETL
• What is the difference between database and data warehouse - ETL?
• What is Data warehouse - ETL?
• What are the benefits of data warehousing - ETL?
• How DTM buffer size and buffer block size are related? - ETL
• When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between Stop and Abort - ETL
• What are the differences between SQL Override and Update Override? - ETL
• What is partitioning and what are some types of partitioning? - ETL
• More...