How to capture rejected records using TD Connector stage

[Himani]

Hi,

Is is possible to capture rejected records through reject link of teradata connector if I am using following properties in Teradata connector stage

Access Method : Bulk
Load Type: Update
Error Control (Duplicate Insert Rows): Reject
Parallel Synchronization: Yes

I have duplicate records in source file which get captured in Error table 2 but do not get rejected through reject link.
My requirement is to capture duplicate/bad data records in Error tables as well as reject them through reject link.

Please suggest

Thanks,
Himani

[mandyli]

Hi

why you are waiting for till end of the TD connector stage?

use Remove duplicate stage and remove it and capture the values at reject file.

Thanks
Man

[qt_ky]

Man, Remove Duplicates stage won't capture duplicate records; it will only eliminate them.