What is a Star schema design? - ETL

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

(Continued from previous question...)

57. What is a Star schema design? - ETL

A Star schema is defined as a logical database design in which there will be a centrally located fact table which is surrounded by at least one or more dimension tables. This design is best suited for Data Warehouse or Data Mart.

(Continued on next question...)

Other Interview Questions

• What are the types of OLAPs ? - ETL
• What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
• In Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how do I do this? - ETL
• What is metadata? - ETL
• What is a Transformation? - 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?
• ETL Testing Techniques:
• Why we use lookup transformation? - ETL
• What is OLTP? - ETL
• Types of Slowly Changing Dimensions: - ETL
• More...