DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
Damonsal



Group memberships:
Premium Members

Joined: 07 May 2014
Posts: 16

Points: 116

Post Posted: Tue May 20, 2014 2:31 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Tried importing table definiton from oracle db using plug in metadata definitoon and orchestrate definition in datastage version 9.1.

When i load the metadata in the oracle connector target stage column size is increasing from 255 to 600 , has any body faced the same situation?

I literally have more than 200+ columns i dont want to manually change this for each and every column.
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54546
Location: Sydney, Australia
Points: 295766

Post Posted: Tue May 20, 2014 4:27 pm Reply with quote    Back to top    

This is almost certainly because you have NLS enabled and Oracle is reporting the byte size (not the character size) for its VarChar2 and Char storage. If you just leave things as they are imported i ...

_________________
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 23, 2014 1:14 pm Reply with quote    Back to top    

Thanks for the information.
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