Informatica User Defined Functions are similar to Built-in Functions, where these functions need to be created once and execute multiple times. Transformation logics that are common across the ports are the ideal candidate for User Defined Functions.
Transformation Logic implemented without User Defined Functions
Validation “IIF( ISNULL(LTRIM(RTRIM(INPUT))),’TRUE’,’FALSE’)” is being performed in multiple ports.
The disadvantage with this approach is any changes to this validation need to be done in all the ports.
This can be addressed by creating a User Defined function and have the logic incorporated there.
Steps to Create User Defined Functions
Step 1 : Right-click on the User-Defined Functions folder in a repository folder in the Designer.
Click on “New”
Step 2: In Editor add the transformation logic / validation that needs to be performed.
Click ok and validate the UDF.
User Defined Function – Type:
Public if the function is callable from any expression. Private if the function is only callable from another user-defined function.
To Call User Defined functions from Port:
.jpg "Oracle Applications")
I think Informatica is one of the best data visualization and integration tool for analysis.It can also be used for solving some complex IT problems.
ReplyDeleteInformatica Read JSON
I could not succeed in CompTIA in two consecutive efforts because I was not having proper material for preparation. I say thanks to my friend who suggested me to use CompTIA PDF Dumps for definite success. Now I am certified in CompTIA and all the credit goes to Dumpspass4sure. If anyone of you is going to appear in this certification then you must choose Pass4sure CompTIA Dumps for your brest results. Don’t forget to practice on testing engine that will give you stringer grip over the concepts.
ReplyDelete