Issue with ODBC connecor in Server Job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
skp
Premium Member
Premium Member
Posts: 135
Joined: Wed Dec 26, 2007 1:56 am
Location: India

Issue with ODBC connecor in Server Job

Post by skp »

Hi All,

We have a job design in server where the same table is reading and writing and then reading, in 9.1 server we have a sparse lookup with ODBC enterprise stage with transformer but before that the same table will be writing the data and the written data is extracting in the next stage. But when we converted it to connector stage and introduces a hashfile in between transformer and connector, connector stage was fetching the data as soon as job starts. Why the connector was fetching the data and why not the enterprise is waiting till the previous stage loads the data.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you show us (the pertinent parts of) your job design?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply