Teradata Multiload Stage
Posted: Thu Sep 28, 2006 6:34 am
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
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