How do you fix the error "OCI has fetched truncated data" in DataStage

  • Interview Candidate
  • 11
  • 12310

Showing Answers 1 - 11 of 11 Answers

Bala

  • Sep 8th, 2005
 

Can we use Change capture stage to get the truncated data's.Members please confirm

  Was this answer useful?  Yes

Lin Chen

  • Oct 17th, 2006
 

I have same problem and don't know what is the solution. I encounter this problem only for part of data.

  Was this answer useful?  Yes

prasoon.pandey

  • Aug 29th, 2007
 

This kind of error occurs when you have CLOB in back end and Varchar in DataStage. So check the back end and accordingly put LongVarchar in the DataStage with the maximum number of length which is used in Database.

  Was this answer useful?  Yes

AjaysKumar

  • Jun 4th, 2008
 

This error occurs when Oracle Stage try to fetch a column like 34.55676776... and actually it's data type is decimal(10,2)The solution here is to either truncate or Round the data till 2 decimal positions

qwert123

  • Jun 29th, 2009
 

The truncation occurs when data type in database(say Oracle) is of type decimal (10,6). But in data stage it's data type is decimal (10,2)). So we need to increase the precision value in the data stage.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions