Upserting data into teradata table

ssunda6 · Post by **ssunda6** » Mon Oct 23, 2006 4:32 am

Hi,
Is there any logic to upsert data from data stage into teradata table with out using teradata multiload stage.If so, please help me.

phanee_k · Post by **phanee_k** » Fri Oct 27, 2006 12:17 pm

You can load the data into a sequential file and load the data into teradata table using a bteq / tpump scripts. It all depends upon your requirement.

phanee_k · Post by **phanee_k** » Fri Oct 27, 2006 12:18 pm

You can load the data into a sequential file and load the data into teradata table using a bteq / tpump scripts if you dont want to use DataStage for loading.

You can even use ODBC stage to load the data .

samsuf2002 · Post by **samsuf2002** » Fri Oct 27, 2006 1:03 pm

using ODBC will be a better choice for ur requirement

ray.wurlod · Post by **ray.wurlod** » Fri Oct 27, 2006 1:36 pm

Why don't you want to use the MultiLoad stage?