Unable to insert records into oracle table

[jagadam]

Hi,

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.

Code: Select all

610W Borwell HB 7556
610W Borwell HB  7556

Thanks in Advance.

[rahcomp]

By default it should insert both the records.

- Make sure you are not setting unique constraint / key constraint on columns which might avoid duplicates

Have you used Sort + Aggregate in the job before load operation

[chulett]

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...

[jagadam]

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.

Thanks in Advance.

[ethanr]

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