Page 1 of 1
Upserting data into teradata table
Posted: Mon Oct 23, 2006 4:32 am
by ssunda6
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.
Posted: Fri Oct 27, 2006 12:17 pm
by phanee_k
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.
Posted: Fri Oct 27, 2006 12:18 pm
by phanee_k
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 .
Posted: Fri Oct 27, 2006 1:03 pm
by samsuf2002
using ODBC will be a better choice for ur requirement
Posted: Fri Oct 27, 2006 1:36 pm
by ray.wurlod
Why don't you want to use the MultiLoad stage?