Q. Most questions about what could be the result from two table data presented before us .
Minus , Left outer Join ( Duplicate Twist ) , Union vs Union ALL , ROW_NUMBER () ,Rank () , DENSE_RANK() ..etc ,
Q.Which Architecture do you use in your Project ( STAR vs SnowFlake - Why SF is not Good ?)
Q. What is Surrogate Key
Q. How did you validate Data from Stage to EDW - Example
Q. What is your Validation Strategy on Large data set
Q. SCD Type - Example pls
