metadata with increased length

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

metadata with increased length

Post by Damonsal »

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
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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 it will work fine.
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 »

Thanks for the information.
Post Reply