TPT

Database
Enthusiast

TPT

I am trying to load a table in teradata using informatica with teradata parallel transported connection with an update operator. I want to see how the data in INFA_ET1 and INFA_ET2 looks like.

So i am trying to pass a null value to a not null field in the target table while loading assuming that all the records will be loaded to INFA_ET1 and INFA_ET2. 

As expected the informatica session failed with the message  "[ERROR] Type:(Teradata DBS Error), Error: (Column 'NEW_QUOT_CNT' is NOT NULL.  Give the column a value.:DMLGroupNum[1]:DMLStatementNum[1]"

But i am not seeing any data loaded to INFA_ET1 and INFA_ET2. What might be the reason for ET1 and ET2 tables being empty?

Tags (1)
1 REPLY

Re: TPT

Hello,

Maybe ErrorLimit is set to zero. ErrorTable1 contains bad data, data conversion error or violation constraint, ErrorTable2 contains any rows that cause violation of unique primary index.

Hugues