Teradata Utilities to load data from table to table

Tools & Utilities

Teradata Utilities to load data from table to table

I want to capture source records that can't be loaded into target table due to data values being inconsistent with expected data types in the target.

My source and target both are teradata tables.

2 REPLIES
Enthusiast

Re: Teradata Utilities to load data from table to table

I am not sure what exactly you want to do. Please provide more details.

My assumption: If you are having source table with column data types which are different than the target table, and you want to ignore the "bad" records and load the "compatible" records to the target table, then you can use TPT + Named Pipe Access Module. In the data connector operatore defintion, you have an attribute which you can specify to ignore the "error" records.

Re: Teradata Utilities to load data from table to table

Yes your assumption is right..

Can you please provide me sample script as I am new to teradata utilities...