erroneous link collector output
Posted: Wed Jul 23, 2008 10:01 pm
Hi,
I have the following job.
Oracle1 ---> Xfm1 ---> link collector ---> sequential file
^
|
Oracle2 ---> Xfm2 -------------|
The output from link collector is always from the previous run's output of Xfm1, which is not expected.
Example:-
1) Run 1
Output from Xfm1: 200 rows
Output from LC: 100 rows
2) Run 2
Output from Xfm1: 500 rows
Output from LC: 200 rows
3) Run 3
Output from Xfm1: 300 rows
Output from LC: 500 rows
Inter-process row buffer is enabled with the default 1024Kb and timeout at 20s.
I get this very consistently and I don't know what is causing this behavior. I tried rebuilding the job and deleting the scratch files but it still doesn't work.
Would appreciate help from anyone.
thanks.
regards,
Desmond
I have the following job.
Oracle1 ---> Xfm1 ---> link collector ---> sequential file
^
|
Oracle2 ---> Xfm2 -------------|
The output from link collector is always from the previous run's output of Xfm1, which is not expected.
Example:-
1) Run 1
Output from Xfm1: 200 rows
Output from LC: 100 rows
2) Run 2
Output from Xfm1: 500 rows
Output from LC: 200 rows
3) Run 3
Output from Xfm1: 300 rows
Output from LC: 500 rows
Inter-process row buffer is enabled with the default 1024Kb and timeout at 20s.
I get this very consistently and I don't know what is causing this behavior. I tried rebuilding the job and deleting the scratch files but it still doesn't work.
Would appreciate help from anyone.
thanks.
regards,
Desmond