compare tables data
Posted: Thu Jan 19, 2012 3:45 am
Hi,
I have pairs of tables metadata is partially matching and I need to compare data of every pair of table most preferably on key column as metadata is partially matching. In output I want the both the tables data count and the mismatch count and a flag column if comparision match or doesnot match.
I want generic Job so that all the pair of tables can be match with out doing any further modification to the job.
Please provide me inputs and revert if anybody needs further details.
I have pairs of tables metadata is partially matching and I need to compare data of every pair of table most preferably on key column as metadata is partially matching. In output I want the both the tables data count and the mismatch count and a flag column if comparision match or doesnot match.
I want generic Job so that all the pair of tables can be match with out doing any further modification to the job.
Please provide me inputs and revert if anybody needs further details.