Records missing

somu_june · Post by **somu_june** » Fri Aug 10, 2007 7:17 am

Hi,

Iam having a job with a Dataset file , transformer and Db2 API stage . Iam trying to insert 3.3 million records in to the target table , Iam missing 650 records in table but those records are present in the dataset and my Datastage Director is not showing me any warnings , there is a ID column in the table with auto generated . But my biggest worry is no warnings are generated for the records that are dropped .

Can some body tell me why it is happening so

Thanks,
Srinu

bandish · Post by **bandish** » Fri Aug 10, 2007 7:21 am

Use a Pivot stage after the DB2 API stage to get the rejected records and their reason for rejection.

somu_june · Post by **somu_june** » Fri Aug 10, 2007 8:12 am

Hi Bandish,

When I tried to use a pivot stage and try to connect from Db2 API stage it is saying stage doesnot support non reject output link whilst it has input links. How can I provide pivot stage after DB2 API it is my final stage in my job

Thanks,
Somaraju

Maveric · Post by **Maveric** » Fri Aug 10, 2007 11:30 am

bandish wrote "Use a Pivot stage after the DB2 API stage to get the rejected records and their reason for rejection." He must have meant Peek stage. Set the Reject records property id DB2 API stage to true and connect the reject link from target to peek stage. You will be able to see the rejected records in the director log.

bandish · Post by **bandish** » Mon Aug 13, 2007 2:47 am

Sorry for the confusion, I actually meant "PEEK" Stage.