Join Not Working on multiple nodes
Posted: Tue Apr 04, 2006 1:59 am
Hi
In one of the parallel jobs I had been using the config file as single.apt(1 node).
The job uses a Oracle reads,Transfomers,JOIN stage and finally Oracle write.
This job has been tested on the testing Environment.
Now for Performance reasons I just tried changing the config File from single.apt to medium.apt(4 nodes)
This actually lead to some incorrect data in the final table.
When i investigated for a specific record, i was able to spot that the join was not working.
Again when i ran with single.apt (For that specific record) It ran fine.
This is really baffling....
Does or not, Join Work with multiple nodes....
Someone please suggest something
TIA,
Venky
In one of the parallel jobs I had been using the config file as single.apt(1 node).
The job uses a Oracle reads,Transfomers,JOIN stage and finally Oracle write.
This job has been tested on the testing Environment.
Now for Performance reasons I just tried changing the config File from single.apt to medium.apt(4 nodes)
This actually lead to some incorrect data in the final table.
When i investigated for a specific record, i was able to spot that the join was not working.
Again when i ran with single.apt (For that specific record) It ran fine.
This is really baffling....
Does or not, Join Work with multiple nodes....
Someone please suggest something
TIA,
Venky