What a static and local variable?
Explain when do we analyze the tables? How do we do it?
Explain what are the different methods of loading dimension tables?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what is full load & incremental or refresh load?
Explain what is the metadata extension?
What are the main steps to build the data warehouse?
Explain what is the difference between datawarehouse and bi?
What is scd1 , scd2 , scd3?
Explain the difference between oltp and olap?
What is a data warehousing?
What is normalization, first normal form, second normal form, third normal form?
Explain where do we use semi and non additive facts?
What is cost benefit analysis (cba)?
Explain what is the data type of the surrogate key?