Hi
I am using a column import stage to convert a single column to multiple columns. I am using a schema file to create the metadata for the output. Are there any ways in which i can define the order in which the columns needs to appear in the output
Eg I have a member number column and balance column(needs to be imported).
Output from import stage is something
like this
Bal1,Bal2,Bal3,Member_number
I need to get the ouput in this way
Member_Number,Bal1,Bal2,Bal3
Not really an answer, per se, but do you not realize that the order you mention those columns in your DML will make absolutely no difference to the result?
-craig
"You can never have too many knives" -- Logan Nine Fingers