target DDL not in order with column metadata

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
Damonsal
Premium Member
Premium Member
Posts: 16
Joined: Wed May 07, 2014 11:29 am

target DDL not in order with column metadata

Post by Damonsal »

Column metadata order is not followed when oracle connector stage is used to create the DDL statement.
IS there any option i say or choose to let connector follow the order i have put on the target oracle connector stage.
Damonsal
Premium Member
Premium Member
Posts: 16
Joined: Wed May 07, 2014 11:29 am

Post by Damonsal »

Column metadata is created in orderly fashion in oracle connector stage, The DDL statement is not following that order.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Why does it matter what order the columns are named in?

For example, in some databases, best performance is had by physically placing all VarChar/VarBinary columns at the end of the record, irrespective of the order in which columns are named in the DDL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Damonsal
Premium Member
Premium Member
Posts: 16
Joined: Wed May 07, 2014 11:29 am

Post by Damonsal »

technically it doesn't matter, but i wanted to create table in a systematic structure, my question is why the connector is not following what order i gave in the target oracle connector stage ?
Post Reply