We are Having SCD Type 2 tables almost 200 tables , with 250 columns in each table.
for
EX: STUDENT details
STUDENT_ID VALID_FROM_DT VALID_TO_DT NAME CITY CONTACT_NO BRANCH
1 04-April-2018 10-April-2018 XYZ Chennai 12345 CSE
1 10-April-2018 31-DEC-2055 XYZ MUMBAI 87777 CSE
looking for some generic solution where to exact only mismatch columns for this case the output should be
OUTPUT :
STUDENT_ID VALID_FROM_DT VALID_TO_DT CITY CONTACT_NO
1 04-April-2018 10-April-2018 Chennai 12345
1 10-April-2018 31-DEC-2055 MUMBAI 87777
Can this solution is possible , if so can it be some generic wherei can use this for all my 200 tables.
Thanks in Advance .