No Re-partitioning. Out put is actually 800 rows.
Found the cause of the problem and we move on. One of the inputs were created by Ascential and not Oracle DDL, when we pre-create the table with Oracle DDL it is giving just 100 rows.
Search found 2 matches
- Fri Jul 13, 2007 8:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Prallel join creating rows as many as nodes
- Replies: 3
- Views: 995
- Wed Jul 11, 2007 9:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Prallel join creating rows as many as nodes
- Replies: 3
- Views: 995
Prallel join creating rows as many as nodes
We are converting server jobs to parallel. Coded a join stage with 2 inputs(oracle enterprise). query gives 100 rows and the join stage gives 800 rows(8 nodes).If we use ODBC stage inputs, it is giving 100 rows.
Is there any parameter or configuration can cause this problem?
Is there any parameter or configuration can cause this problem?