Code: Select all
S.no Name dept salary dept
1 Raul Real 2000 S&F
2 Raul ACM 1000 R&D
3 Raul ACM 1000 K&P
When ever there is a mis match i have have to write it to the output recoed and set a indicator.
For example, When i comapre the first record with second in the above example, field dept in record
one is different from record 2
The output should be like
Code: Select all
S.no Name NewTeam OldTeam OldSal NewSal NewDept Old Dept
1 Raul real ACM
output record.
Code: Select all
S.no Name NewTeam OldTeam NewSal OldSal NewDept OldDept
1 Raul 2000 1000
output record.
Code: Select all
S.no Name Newteam Oldteam NewSal NewSal NewDept Olddept
1 Raul S&F R&D
Raul