How to I know how many tables or which table being loaded by Teradata TPT

Database
Teradata Employee

How to I know how many tables or which table being loaded by Teradata TPT

I am using  ETL tool "Attunity" which call TPT task to load data into TD15. when loading task is running, all SQL statement relate to this table will get "XXXX table being loaded" message. (Error Code : 2652)

I know that fastload will insert one record in SysAdmin.Fastlog when table being loaded. 

Is there any method to know how many tables or which table being loaded by TPT task ?

 

Carlyle

1 REPLY
Apprentice

Re: How to I know how many tables or which table being loaded by Teradata TPT

Hi Carlyle.

 

(Not terribly technical but...) Assuming that by 'TPT task' you are meaning a 'TPT Load' or 'TPT Update' task, then have you thought about querying DBC.TablesV for the existence of the error tables? Those will be created when the task starts and dropped (if empty) when it finishes.

 

If not controlled by you, there is almost certainly a naming convention that allows the target table name to be derived from the error table names.

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com