Types of Slowly Changing Dimensions: - ETL

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

(Continued from previous question...)

74. Types of Slowly Changing Dimensions: - ETL

Type – 1 (Recent updates)
Type – 11 (Full historical information)
Type – 111 (Partial historical information)

(Continued on next question...)

Other Interview Questions

• What is Operational Data Store? - ETL
• What is Factless Fact table? - ETL
• What is factless fact schema? - ETL
• When do we Analyze the tables? How do we do it? - ETL
• What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
• What are the applications of data warehouse? - ETL
• Advanced ETL Interview Questions - If there are ten thousand records in a source system, how do we ensure that all ten thousand are loaded to the target without any dysfunctional values?
• What is the difference between database and data warehouse - ETL?
• How to fine tune mappings? - ETL
• ETL or Data warehouse testing is categorized into four different engagements irrespective of technology or ETL tools used:
• More...