First Republic interview question

Questions on Transaction Control Transformation, SCD Type 2, Look up performance etc.