Below are the address records in source and Datastage is treating both the records as one though there is an space after HB. Is there any way DS can load both the records into target oracle table.
This question really can't be answered without more information from you. We have no idea what your job design looks like, what your source and target are, nor what your transformation / business rules are. For all we know you are trimming the string and thus making the two values equal...
-craig
"You can never have too many knives" -- Logan Nine Fingers
Yes we do have unique key contraint on the table. Doesn't datastage and oracle considers those records as two different records?
The job design is of SCD Type 1 and SCD stage is not considering as new record compared to already existing dimension record .let's say source has those 2 records and dimension has one of those record and the output of SCD stage is zero records. There are 3 keys which are unique on the table. Address is one of the unique key. Please let me know what needs to be done in order to recognize those records as 2 different records for SCD and ORACLE.
More information may help all. At high level consider Datatype (Char or varchar). Also do you perform any trim operations? Consider APT_STRING_PADCHAR value, is this affecting data in any way