DB loading

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

Post Reply
kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

DB loading

Post by kennyapril »

I am using ODBC connector to insert records into a table.

I read the data from two flat files each one has around 7 to 10 variables.

I need to insert 5 from one flat file and 6 from the other flat file.
These two files have a common varible.

which stage is better to use before loading into the table to get the combined variables?

Does Join work out?
Regards,
Kenny
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Yes, because of the common domain.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”