Teradata TPT Load method

Akhobare · Post by **Akhobare** » Thu Mar 17, 2011 4:14 am

Hi ,
I need to confirmation about a case where i am fetching data from Teradata table and loading data into same table through TPT stage in same job.

As of now , job is loading data without any misappropriation. What i understand TPT->Bulk->Load is fastLoad method. So it should create empty work table , load data in it , then append work table data in target(source) table , lastly drop work table.( At least this holds true in Tedata Enterprise stage).

Can anyone endorse above understanding for TPT stage? OR reading & loading data from/in same table in same job can be errornuous/risky?

Thanks in advance.

Akhobare · Post by **Akhobare** » Fri Mar 18, 2011 2:13 am

Can any one reply to above question?

chulett · Post by **chulett** » Fri Mar 18, 2011 7:33 am

Sorry... I have no Teradata experience. Hopefully someone who does will be along.

Akhobare · Post by **Akhobare** » Sun Mar 20, 2011 11:42 pm

np...

I had reply from within the team and as per reply, read ( simple fetch or through SQLs) always completed prior to load.
Besides while doing fastload (bulk --> load in append mode) orchstrate work table is created and loaded with data , then appended to target table.
So there shouldn't be any issue.
If still someone not convinced , in source SQL don't use 'Locking table .. for ACCESS'. Read lock on table will ensure records are read first and when its completed loading can start.

Thanks