Hello,
I have a warning in my Job. Warning: Data has been truncated.
The job extracts data from Oracle and loads it into SQL Server. When I extract the data I convert it from ms12 to UTF8 because I have a problem with specific characters?
The NLS in DataStage is MS1252 and in Oracle AL32UTF8 and UTF8 in SQL Server
I have change the metadata (length) of field but the problem persists
Warning: Data has been truncated
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
any other warning or just this one?
Anyways, try to find if there is any difference between the table structure defined in the job and in database.
If its UTF8 in source and target, any particular reasons for not using the same character set on datastage?
It doesn't look like that in the data you posted but do you have any multi-byte/accented/special character in your source data causing overflow in bytes assigned?
Anyways, try to find if there is any difference between the table structure defined in the job and in database.
If its UTF8 in source and target, any particular reasons for not using the same character set on datastage?
It doesn't look like that in the data you posted but do you have any multi-byte/accented/special character in your source data causing overflow in bytes assigned?
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
Hi,
Try to check actual column lengths.
sometimes even the wrong size in ds compared with DB can cause this.
if you had any special cars the you wouls have ot NLS warning since ms1252 does't support them.
IHTH,
Try to check actual column lengths.
sometimes even the wrong size in ds compared with DB can cause this.
if you had any special cars the you wouls have ot NLS warning since ms1252 does't support them.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org