DataStage Parallel Edition Error (Join Stage)
Posted: Fri Jun 27, 2008 12:16 pm
Hi,
Iam Joing two Stages with one stage as "Dataset" and another stage is "DB2" , joining with three KEY columns.
When i execute the Query in DB2, iam getting "FOUR" records but the same JOIN query is giving me "EIGHT" records in DataStage which is repeated rows[4*2=8]
If any additional info pls get back to me...
Thanks in advance..
Iam Joing two Stages with one stage as "Dataset" and another stage is "DB2" , joining with three KEY columns.
When i execute the Query in DB2, iam getting "FOUR" records but the same JOIN query is giving me "EIGHT" records in DataStage which is repeated rows[4*2=8]
If any additional info pls get back to me...
Thanks in advance..