DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Damonsal



Group memberships:
Premium Members

Joined: 07 May 2014
Posts: 16

Points: 116

Post Posted: Fri May 16, 2014 9:23 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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



Group memberships:
Premium Members

Joined: 07 May 2014
Posts: 16

Points: 116

Post Posted: Fri May 16, 2014 10:21 am Reply with quote    Back to top    

Column metadata is created in orderly fashion in oracle connector stage, The DDL statement is not following that order.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54539
Location: Sydney, Australia
Points: 295735

Post Posted: Fri May 16, 2014 3:19 pm Reply with quote    Back to top    

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, irres ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Damonsal



Group memberships:
Premium Members

Joined: 07 May 2014
Posts: 16

Points: 116

Post Posted: Fri May 16, 2014 8:04 pm Reply with quote    Back to top    

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 ?
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours