Extract Multiple table

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
Amin
Premium Member
Premium Member
Posts: 27
Joined: Fri Oct 24, 2014 10:02 am

Extract Multiple table

Post by Amin »

Is there any configuration for extracting multiple tables of same database into multiple Data Set using single connector(On Single DB Connection).
My DBMS is DB2.
Thomas.B
Participant
Posts: 63
Joined: Thu Apr 09, 2015 6:40 am
Location: France - Nantes

Post by Thomas.B »

A DB2 Connector can only have one "Stream" output, so, you can only create one DataSet at a time.

The easiest way to extract multiple tables to multiple DataSets is to create a generic multiple instance job with the name of the table and the name of the DataSet as parameters.
Post Reply