Issues with loading data from flat file to teradata target

Tools & Utilities
Enthusiast

Issues with loading data from flat file to teradata target

Hello All,

 

I was trying to load some data from flat file to target table in teradata. An MLOAD upsert connection string was defined in informatica for this purpose. But I could not see some records in the final target which were present in flat file.

 

Can anyone guide me how to findout the rootcause. I could not see any script linked to loader connection. I was checking based on PARTY_ID which is INTEGER,NOT NULL and UPI in target table. The same colum is defiend as string for source in informatica mapping.

 

Let us know if you are looking for any further information.

 

Thanks,

Prasanth.