Hi all,
when i import the metadata from the oracle tables the length is being changed by four times..eg the datatype is varchar2(30 char) is converted to varchar2(120) in the datastage..
why is this happening..and how is it happening?
If my datatype and length of the column is varchar2(1000 char)
it is converted to varchar2(4000) i heard that this might cause problems while data in the database..
what should i do..??
length conversion in the datastage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Did you try importing the meta-data in both ways?
Through ODBC and through Plug-in Meta-data imports.
If you didn't, then I would suggest to check if the other makes any difference.
Whale.
Through ODBC and through Plug-in Meta-data imports.
If you didn't, then I would suggest to check if the other makes any difference.
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is this the same question as your post about Char(1) containing four characters?
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.