Capgemini interview question

SCD types, sql qry - intersect, union , Infa - LKP transformation