Pipeline Lookup Transformation, Beyond Relational and Flat File Data Sources

Pipeline Lookup Transformation, Beyond Relational and Flat File Data Sources

Lookup transformation is synonymous to SQL outer join, which is primarily used for relational and flat file data source lookups. But with the introduction of pipeline lookup, we can use all variety of data sources in the lookup transformation. This feature is really powerful just like Active Lookup Transformation. In this article lets see how pipeline lookup transformation can be configured in a mapping.

Continue Reading

User Defined Functions in Informatica PowerCenter

User Defined Functions in Informatica PowerCenter

Reusability is a great feature in Informatica PowerCenter which can be used by developers. Its general purpose is to reduce unnecessary coding which ultimately reduces development time and increases supportability. User Defined Functions is one among the reusability feature provided by Informatica PowerCenter. In this article lets understand User Defined Functions in detail.

Continue Reading

Re-Runnability for Informatica ETL Processes Which Uses Mapping Variables

Re-Runnability for Informatica ETL Processes Which Uses Mapping Variables

Informatica PowerCenter mapping variable can be effectively used to implement change data capture logic. The mapping variable is stored in the repository and its value is set to the new value only when the session execution is successful. This property makes the restartability of the ETL process easy. Since the last success point - variable value, is stored in repository, we cannot go back and reprocess an already processed data set.  In this article lets see how we can handle overriding the mapping variable value.

Continue Reading

Rank Transformation to find TOP or BOTTOM Ranked Data Sets

Rank Transformation to find TOP or BOTTOM Ranked Data Sets

Rank Transformation can be used to rank record sets and return records with the largest or smallest rank with in a group based on a port value. You can also use a Rank transformation to return the strings at the top or the bottom of an ordered data. In this article lets discuss a practical application of Informatica Power Center Rank Transformation.

Continue Reading

Build Reusable Code in Informatica PowerCenter Using Mapplets

Build Reusable Code in Informatica PowerCenter Using Mapplets

Reusability is a great feature in Informatica PowerCenter which can be used by developers. Its general purpose is to reduce unnecessary coding which ultimately reduces development time and increases supportability. In this article lets see how we can build mapplet in Informatica PowerCenter to make your code reusable.

Continue Reading