Wednesday, 31 August 2011

Informatica Installation...

Informatica Basics Tutorial

Informatica Basic Study Tutorial

Informatica Power center 8.x Architecture...

Very good presentation on Informatica Powercenter 8.0....
Powercenter Informatica 8.0 (Datawarehousing and ETL Tool)

Sunday, 28 August 2011

Creating User Defined Function in Informatica....

• In Informatica go to Tools ->User-defined Functions..

• Click on New… which is on right hand side of window.
• Fill the fields as shown below.
Public User Defined functions can be called from any transformation expression.
Private User Defined functions can be called only from other User defined functions.




• You can call this UDF using expression editor…