Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
ssunda6
Participant
Posts: 91 Joined: Tue Sep 19, 2006 9:32 pm
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
Charter Member
Posts: 68 Joined: Thu Nov 20, 2003 11:02 pm
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
Charter Member
Posts: 68 Joined: Thu Nov 20, 2003 11:02 pm
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
Premium Member
Posts: 397 Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse
Post
by samsuf2002 » Fri Oct 27, 2006 1:03 pm
using ODBC will be a better choice for ur requirement
hi sam here
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Oct 27, 2006 1:36 pm
Why don't you want to use the MultiLoad stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.