Hi,
I want to use a teradata multiload stage in my job to store the data into the table.My reading the data from a sequential file.Can anyone tell me what are the different types of settings that are to be done while updating the table.(any option Insert, Update, Upsert)
i have used the following things
Data Format=Fast Load
Load Method =Invoke Load Utility
Load type=Upsert.
i have also tried with Custom option .
Please let me know if they are any settings that are to be done ?
Please give a detail approach .
Thanks
Teradata Multiload Stage
Moderators: chulett, rschirm, roy
-
goriparthi
- Charter Member
- Posts: 57
- Joined: Fri Feb 24, 2006 7:44 am
hi,
you need to give the path where the error tables and the work tables and the log tables to be generated , also mention the session max, session min ,error limit , checkpoint e.t.c all these mentioned either in your stage or job properties as variables.
you need to go to the report file to check the status of the job as it will be having the detailed description of the process going on of all the multiload phases .
Hope it helps.
Raj
you need to give the path where the error tables and the work tables and the log tables to be generated , also mention the session max, session min ,error limit , checkpoint e.t.c all these mentioned either in your stage or job properties as variables.
you need to go to the report file to check the status of the job as it will be having the detailed description of the process going on of all the multiload phases .
Hope it helps.
Raj