Code: Select all
Dim table
Oracle Enterprise stage
|
| Reference link
Primary link |
Source table-------------------------SCD----------------------------------.\NUL
Oracle Enterprise stage | Output link Sequential file stage
|
| Dim changes link
|
Peek stage
The expected result is for 0 rows to go down the dimension changes link, and this is what happens if I run the job on a single node.
But if I run the job on 2 nodes, I get 5 rows on the dimension changes link. If I run on 4 nodes I get 8 rows. These rows are insert (ie unexpired) rows, indicating that they were not found on the reference link.
I'd like this job to run consistently regardless of the number of nodes. Can anyone give me a hint on where to start looking?
Thanks