Writting order of the data into table is changing from sourc

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srinivas Guduru
Premium Member
Premium Member
Posts: 38
Joined: Sat Dec 29, 2007 9:58 am

Writting order of the data into table is changing from sourc

Post 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Curious how this is an issue as there is no 'order' to how data is stored in a relational table.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply