Datastage Job Design

chulett · Post by **chulett** » Tue Feb 27, 2007 7:52 am

Welcome.

How about posting your complete job design? Curious how you are 'merging' the input from three (separate?) ODBC stages for loading via a fourth. Also, any chance that your target table is one of the three source tables and you are blocking yourself?

How long do you wait before you decide that it isn't processing any rows? How 'complex' are your source queries? Those aren't large quantities but depending on a number of different variables, badly executing queries could take quite some time to start returning anything...

AthiraM · Post by **AthiraM** » Tue Feb 27, 2007 8:09 am

Hi,

The three ODBC stages as mentioned connects to 3 different tables in an Oracle database and the output is given to a table in a different Oracle database.
I waited for almost 8 hours

chulett · Post by **chulett** » Tue Feb 27, 2007 8:50 am

AthiraM wrote:The three ODBC stages as mentioned connects to 3 different tables in an Oracle database and the output is given to a table in a different Oracle database.

Doesn't really answer the job design question. Please list all of the stages used in the job. An 'ascii art' version can be posted if you use Code tags and liberal use of the 'Preview' option. Or Image tags if you upload a screenshot somewhere.