Page 1 of 1
target DDL not in order with column metadata
Posted: Fri May 16, 2014 9:23 am
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.
Posted: Fri May 16, 2014 10:21 am
by Damonsal
Column metadata is created in orderly fashion in oracle connector stage, The DDL statement is not following that order.
Posted: Fri May 16, 2014 3:19 pm
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.
Posted: Fri May 16, 2014 8:04 pm
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 ?