OCI Stage - Data not loaded in a sorted order
Posted: Thu May 12, 2005 5:57 pm
Hi Everyone,
I observed this many times. When i load data from a sequential file to oracle using a OCI stage the data is not getting loaded in the same order in which it is available in the sequential file.
For eg:
sequential file has records like..
1990 Q1 12
1990 Q2 13
1990 Q3 12
1990 Q4 13
1991 Q1 12
1991 Q2 13
1991 Q3 12
1991 Q4 13
1992 Q1 12
1992 Q2 13
1992 Q3 12
1992 Q4 13
i run the job which reads from seq file passes through the transformer (no derivations - direct mapping) and loads into oracle using OCI stage.
The output is not in the same order.
It may load like
1991 Q3 12
1991 Q4 13
1992 Q1 12
1992 Q2 13
1990 Q1 12
1990 Q2 13
1990 Q3 12
1990 Q4 13
1991 Q1 12
1991 Q2 13
1992 Q3 12
1992 Q4 13
Any idea why it is loading like this? Is it common? i observed this in many of my jobs.
Any ideas will be helpful.
Thanks,
Srikanth
I observed this many times. When i load data from a sequential file to oracle using a OCI stage the data is not getting loaded in the same order in which it is available in the sequential file.
For eg:
sequential file has records like..
1990 Q1 12
1990 Q2 13
1990 Q3 12
1990 Q4 13
1991 Q1 12
1991 Q2 13
1991 Q3 12
1991 Q4 13
1992 Q1 12
1992 Q2 13
1992 Q3 12
1992 Q4 13
i run the job which reads from seq file passes through the transformer (no derivations - direct mapping) and loads into oracle using OCI stage.
The output is not in the same order.
It may load like
1991 Q3 12
1991 Q4 13
1992 Q1 12
1992 Q2 13
1990 Q1 12
1990 Q2 13
1990 Q3 12
1990 Q4 13
1991 Q1 12
1991 Q2 13
1992 Q3 12
1992 Q4 13
Any idea why it is loading like this? Is it common? i observed this in many of my jobs.
Any ideas will be helpful.
Thanks,
Srikanth