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:DMLStatementNum"
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?
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.