Loading duplicate rows using teradata connector
Posted: Tue Jul 23, 2013 3:22 am
Hi,
I am migrating a job from 8.1 version to 8.7. This job loads data into a teradata table which is having UPI on key columns and source data is expecetd to have duplicate rows, so in 8.1, multiload stage in sequential mode is used to counter this situation, However in 8.7 using connector I am not able to execute this job, as it gets aborted due to constraint violation. I have set the connector to sequential mode, even then it gets aborted.
I am migrating a job from 8.1 version to 8.7. This job loads data into a teradata table which is having UPI on key columns and source data is expecetd to have duplicate rows, so in 8.1, multiload stage in sequential mode is used to counter this situation, However in 8.7 using connector I am not able to execute this job, as it gets aborted due to constraint violation. I have set the connector to sequential mode, even then it gets aborted.