I am doing a lookup on input data from a file with a Oracle Enterprise stage. When i view data in oracle enterprise stage i am able to see rows returned. But when i run the job no records were passed through the reference link which is coming from the oracle Enterprise stage.The job ran fine during some of the initial runs(passing rows on the reference link). But after that, its giving this problem. I tried force compiling the job.But, the result is the same.
All view data working means is it can read the table, the fact that all lookups fail (and are thus rejected) means your key values are not matching... hence Ray's query.
-craig
"You can never have too many knives" -- Logan Nine Fingers
May be the records are not matching with the oracle stages so all the records are getting rejected. If i am not wrong the reference link will display the matched record count. if there is no match so u are getting 0 in reference link. try monitoring the job from director or put a copy stage in between the oracle---copy--lookup... just see how many records are coming from the oracle to copy stage in link