OCI Stage - Data not loaded in a sorted order

[rsrikant]

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

[ray.wurlod]

It is a fundamental rule of databases that order of storage is not determinable. The database server makes its own decisions about where to store things. Unless you specify ORDER BY in a query to retrieve those data, you'll get whatever the database server chooses to give you.

This is NOT a DataStage issue.

[chulett]

It's not even an issue, just The Way It Works.