Implicit conversion Error

[G_rajeshk]

Hi All,

Could you please help me..Im getting the following error msg.

##I IIS-DSEE-TFCN-00006 09:11:42(001) <main_program> conductor uname: -s=AIX; -r=1; -v=7; -n=srabists01; -m=00CF12C64C00
##I IIS-DSEE-TOSH-00002 09:11:42(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 09:11:42(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 09:11:42(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 09:11:42(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W IIS-DSEE-TFTM-00012 09:11:42(009) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W IIS-DSEE-TFEV-00025 09:11:42(010) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 09:11:42(011) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 09:11:42(012) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 09:11:42(013) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 09:11:42(014) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 09:11:42(015) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##E IIS-DSEE-TFEV-00015 09:11:42(016) <transform> Error when checking composite operator: Only an input field can be "notnull" function argument: [line 59,character 13].
##E IIS-DSEE-TFEV-00015 09:11:42(017) <transform> Error when checking composite operator: Only an input field can be "notnull" function argument: [line 59,character 13].
##E IIS-DSEE-TFEV-00018 09:11:42(018) <transform> Error when checking composite operator: A composite call is not supported for function "notnull"; [line 59,character 13].
##E IIS-DSEE-TFSR-00019 09:11:42(019) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 09:11:42(020) <main_program> Creation of a step finished with status = FAILED. (DM_EDW_FCT_AC_IVSM_DLY_SNPST_Test.xfm_Data_Processing)
----------------------------------------------------------------------------
My Source Data Column

Qty Decimal (18,6)
PRC Decimal (14,2)

So I need to do this with following output Column

RNG_VALUE = (Qty / PRC * 100) Decimal (8,5)

Im not sure could you please help us.

Thanks
Raj

[SURA]

Are you doing something in the Stage Variable?

[jwiles]

Instead of of multiplying by 100 multiply by 100.0

Look at this error:

Code: Select all

##E IIS-DSEE-TFEV-00015 09:11:42(016) <transform> Error when checking composite operator: Only an input field can be "notnull" function argument: [line 59,character 13]. 
##E IIS-DSEE-TFEV-00015 09:11:42(017) <transform> Error when checking composite operator: Only an input field can be "notnull" function argument: [line 59,character 13]. 

You can't use an output field or stage variable (which typically can't be null) as an argument to the NotNoull() function.

Regards,