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...
Datastage Job Design
Moderators: chulett, rschirm, roy
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.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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers