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.
Teradata TPT Load method
Moderators: chulett, rschirm, roy
Teradata TPT Load method
Regards,
Akshay
Akshay
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
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
Regards,
Akshay
Akshay