HI
Inside the OracleENterprise plugin for the columns type decimal I am getting the following error.Job is successful.
Could any body please help me in this.
Oracle_Enterprise_61: When checking operator: When binding output interface field "BIRTHWEIGHT" to field "BIRTHWEIGHT": Implicit conversion; from source type "int64" to result type "decimal[10,0]": Possible range limitation
thnaks
Nivas
Warinings with ORacle Enterprise plugin
Moderators: chulett, rschirm, roy
You are converting data from an integer to decimal. In DataStage, you do not do that without explicitly converting it, due to the possibility of truncation.
For DataStage EE, Oracle's Number(10) is a Decimal(10,0). Oracle's Number() is an Integer.
So ensure that your data being provided is as Decimal(10,0). You need to do StringToDecimal() function call within the Transformer.
For DataStage EE, Oracle's Number(10) is a Decimal(10,0). Oracle's Number() is an Integer.
So ensure that your data being provided is as Decimal(10,0). You need to do StringToDecimal() function call within the Transformer.