hi
625907Feb 29 2008 — edited Mar 1 2008I have a source table and target table with 2,00,000 rows. From source I loaded in to target with no transformation. But some characters are missing in some records of target table. how do i compare target against the source to get those records where some characters are missing..
Ex.
In source table i got the record with value as:
duplicate of invoice 1172232, issuing a credit dispute
In target table i got the record with value as:
duplicat of invoic 1172232, issuing a cr dit disput
Character 'e' is missing in target table..
in the place of 'e' i get space.
So i want to compare those records.. how can i find out those records..
how to find the records which have missing character.
Pls help me find out.. i'm a fresher...