As I understood from the document that private (UDF fn_calcTax) can be used only in another user defined function (public function).
Is it correct?
That is correct.
Then can you please give expression like how to call that private (fn_calcTax) function.
Example How I understood and testing .
Private Fn_calcTax(Salary decimal) defined in designer and expression is
salary * 0.123
Public fn_calNetSalary(Salary decimal, Tax Decimal) Defined in Designer with Public scope and expression is
Salary – Tax
I utilized those function in expression transformation like
:UDF.CalNetSalary(salary, Fn_calcTax(salary))
The system gives wrong expression and it doest not able to identify that Private function.
Could you pls help me out on this? If possible please provide an example how to call private function in expression.
That is incorrect (My understanding).
You can't call the private function in an expression.
The only place you can use private functions is in the
definition(s) of other function(s).
The example you gave, you're trying to use the private functions in the expression you use to invoke the public function.
You can't do that.
You can however, use Fn_calcTax in the definition of fn_calNetSalary -
Public fn_calNetSalary(Salary decimal) Defined in Designer with Public scope and expression is
Salary – Fn_calcTax(salary)
And you can always invoke it like so -
:UDF.CalNetSalary(salary)
disclaimer - I've been out of touch with Informatica for almost three years now, so the above can be a little rusty.
And all I've said above could be completely wrong.
© Copyright 2006-2010 DW Forum. All rights reserved.