Say in a source there are 1 lakh records and in Target there are 1 lakh records. Some records in a column having the mismatch value (.ie., Instead of displaying 1000 in a column, it is displaying as 100 in Target column) The source file is from an DB2 and, Oracle (different source) and, Target is an SQL server. So how to find it by a simple way?

santhosh gujja

• Oct 15th, 2015

1) Select * from source -- Convert this output to a Excel Sheet
2) Create an empty table with the same table structure as of source and Load the excel sheet into that table in SQL Server.
Then compare the results by using minus query between source and target within SQL Server.

mukesh

• Sep 28th, 2015

Considering the source as correct data. Use source data as an external file in oracle and use a MERGE command to Update the date ( Correct the data in the target) or Insert if the entire record is missing. MERGE with External table will be very fast as oracle take care of the parallel load.

Answer Question  Select Best Answer