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.
metadata with increased length
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.