DSXchange

Hi,

I have a similar job which has OCI input with more than 8 lookups which I have turned into hashed files lookups but the performance is still bad. Less than 10 rows per sec !

What else can I do to improve the performance ?

Hi,

Pardon my ignorance but just another question :

Is there a way to stop writing to a output record from the pivot stage if one of the 3 fields is NULL instead of filtering them out later in the process ?

i.e input A, B1,B2,B3,C , if B3 is empty, I want only 2 records :

A,B1,C
A,B2,C

I turn all oracle tables to sequential files and the pivot stage works fine...

Thanks for the help.

I was able to simulate the problem with 2 different jobs. I have 2 jobs that use pivot stage and both gave me the same error. One job has input oracle stage -> pivot stage -> transformer stage. Another job has input oracle stage -> pivot stage -> output oracle table. In both cases, the job aborted a...

Hi all, I've been trying to use Pivot stage to take an input Oracle table record, go through a transformer stage and output to another oracle table with multiple records. THe input table has 19000 records to be output to 19000 x 3 records in output. However after processing till the end, I get an ab...