DSXchange

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.

Can any one reply to above question?

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

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