Hi,
I am trying to load data into Oracle tbl. And I am getting this error saying "Data has been truncated".
I checked the size, datatype of the fields in my transformations and Oracle tbls and they match.
What else could be the problem. Did anyone come across this problem.
Any suggestion would be appreciated.
Thanks,
Sri.
Data Has been Truncated
Moderators: chulett, rschirm, roy
This msg is a warning in the datastage. When I check the data in the msg box, the data is built correctly, but is not written into the oracle tbl.
This is the msg i get.
GL_Facts..Fact_Dimension_Lkp.tgt_Fact_tbl: DSD.BCIPut call to SQLExecute returned informational message.
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
Thanks,
Srikanth.
This is the msg i get.
GL_Facts..Fact_Dimension_Lkp.tgt_Fact_tbl: DSD.BCIPut call to SQLExecute returned informational message.
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
Thanks,
Srikanth.
Yes it would, that's why I asked.
What size did you declare it in DataStage? 38? If you did, try bumping the declared size of the field in your job to 40 and the message should stop. Don't change anything else, just the size of the target field.
ps - Using ODBC? Why not use the native OCI stage?
What size did you declare it in DataStage? 38? If you did, try bumping the declared size of the field in your job to 40 and the message should stop. Don't change anything else, just the size of the target field.
ps - Using ODBC? Why not use the native OCI stage?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers