Oracle Stage
Posted: Fri Apr 02, 2004 4:01 pm
Hello All,
I have a job that reads from 3 Oracle tables and writes to a flat files with some operators(sort, join & transformer) in between.The data from Oracle goes to a sort operator and then to a join operator.
When I run the job it completes successfully. I get the no of rows I'm expecting, but when I click on new monitor under Tools in Director, the status for data coming out of the 2 oracle stages is Unknown and number of rows is zero. The 3rd Oracle stage has data going out of it fine. When I click on show performance statistics on Designer, all the links are green except the link joining Oracle to sort.
Does anyone have any idea what is going on here ?
Please help.
Raj
I have a job that reads from 3 Oracle tables and writes to a flat files with some operators(sort, join & transformer) in between.The data from Oracle goes to a sort operator and then to a join operator.
When I run the job it completes successfully. I get the no of rows I'm expecting, but when I click on new monitor under Tools in Director, the status for data coming out of the 2 oracle stages is Unknown and number of rows is zero. The 3rd Oracle stage has data going out of it fine. When I click on show performance statistics on Designer, all the links are green except the link joining Oracle to sort.
Does anyone have any idea what is going on here ?
Please help.
Raj