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
-
aschand
- Participant
- Posts: 57
- Joined: Thu Jan 03, 2008 9:28 pm
Post
by aschand »
Can any one please help me with this issue
the data in the source for a column is '1234566777888' (stored as character)
but in the target table it is stored as '1234566777' only i.e; accepting only upto 10 characters
other columns with same data type are able to handle large values bigger than this.
this this one particular column has the issue.
no function is used here... but it is not able to load the whole value though the column datatype as size is Nvarchar(100)
thanks
aschand
-
paddu
- Premium Member
- Posts: 232
- Joined: Tue Feb 22, 2005 11:14 am
- Location: California
Post
by paddu »
what is your source ???
all the values in this column have this issue or only few values ????
-
aschand
- Participant
- Posts: 57
- Joined: Thu Jan 03, 2008 9:28 pm
Post
by aschand »
thanks... it got solved
-
paddu
- Premium Member
- Posts: 232
- Joined: Tue Feb 22, 2005 11:14 am
- Location: California
Post
by paddu »
then please mark this topic as resolved
-
VCInDSX
- Premium Member
- Posts: 223
- Joined: Fri Apr 13, 2007 10:02 am
- Location: US
Post
by VCInDSX »
While closing the thread, if you could also throw some light on how you fixed this issue, it will be of help for "future" generations.
Cheers!!!
-V