Page 1 of 1

Writting order of the data into table is changing from sourc

Posted: Wed Apr 20, 2011 3:05 pm
by srinivas Guduru
I am reding from txt file with SEQUENTIAL STAGE using schema file and i am loading into the data into Oracle table using Oracle Enterprise stage.

Sequential file stage ----> Transformer ------> OracleEnterprise stage

The writting order of the data in the target table is not same as order of the data in the source txt file.

I used auto partion method.

Can some one advise me in this regard

Thanks

Srini

Posted: Wed Apr 20, 2011 4:17 pm
by chulett
Curious how this is an issue as there is no 'order' to how data is stored in a relational table.