This blog is all about topics related to ETL , Data Warehousing,Informatica ,ETL Tools ,SAS and other topics which will be helpful to ETL developers.
Wednesday, 31 August 2011
Informatica Installation...
Informatica Power center 8.x Architecture...
Very good presentation on Informatica Powercenter 8.0....
Powercenter Informatica 8.0 (Datawarehousing and ETL Tool)
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…
• 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…
Subscribe to:
Posts (Atom)