Informatica Powercenter – User Defined Functions

User Defined Function (UDF’s) is a way Powercenter gives us to create our own personal, reusable, functions. We can use our UDF’s in Expression Transformations in order to reuse expression logic. For instance, if you want to RTRIM() LTRIM() and UPPER() several ports, so, instead of writing all these 3 functions all the time youContinue reading “Informatica Powercenter – User Defined Functions”

Informatica Powercenter – Mapplets

Here what official documentation says about Mapplets: A mapplet is a reusable object that you create in the Mapplet Designer. It contains a set of transformations and lets you reuse the transformation logic in multiple mappings. When you use a mapplet in a mapping, you use an instance of the mapplet. Any change made toContinue reading “Informatica Powercenter – Mapplets”

Informatica Powercenter – Update Strategy Transformation SCD1 SCD2

Something worth keeping in mind: in order to Update Strategy to work properly you need to make sure that your target table has a primary key. Here’s what the official documentation says about Update Strategy Information: “The Update Strategy transformation is an active transformation. When you design a data warehouse, you need to decide whatContinue reading “Informatica Powercenter – Update Strategy Transformation SCD1 SCD2”

Informatica Powercenter – Union Transformation

If you are familiar to SQL you already know what UNION does. In fact, you might be wondering, is Powercenter Union the same as SQL union or SQL union all? It is UNION ALL. Here’s the official documentation on Powercenter Union transformation: The Union transformation is a multiple input group transformation that you use toContinue reading “Informatica Powercenter – Union Transformation”

Informatica Powercenter – Joiner Transformation

Here’s what the official documentation says about the Joiner Transformation: Use the Joiner transformation to join source data from two related heterogeneous sources residing in different locations or file systems. You can also join data from the same source. The Joiner transformation joins sources with at least one matching column. The Joiner transformation uses aContinue reading “Informatica Powercenter – Joiner Transformation”

Informatica Powercenter – Filter Transformation

Let see what the official documentation says about Filter Transformation: “Use the Filter transformation to filter out rows in a mapping. As an active transformation, the Filter transformation may change the number of rows passed through it. The Filter transformation allows rows that meet the specified filter condition to pass through. It drops rows thatContinue reading “Informatica Powercenter – Filter Transformation”

Informatica Powercenter – Lookup Transformation

What is lookup? Whoever is familiar with Excel’s VLOOKUP might understand what this is about, but, anyway, let’s check what the official documentation says about it:“ “Use a Lookup transformation in a mapping to look up data in a flat file, relational table, view, or synonym. You can import a lookup definition from anyContinue reading “Informatica Powercenter – Lookup Transformation”

Informatica Powercenter – Aggregator Transformation

In the image above we can see inside of a aggregation transformation in Informatica Powercenter. So Aggr transformation can be any of those, Avg, Count, First, last, SUM, etc. For our example I will use this as baseline: We have the SQ_EMP_FILE table and here’s how I want this table to look like after myContinue reading “Informatica Powercenter – Aggregator Transformation”

Informatica Powercenter – Source Qualifier Trasformation

Here’s what the official documentation says about Source Qualifier transformation: The Source Qualifier transformation represents the rows that the Integration Service reads when it runs a session. The Source Qualifier transformation is an active transformation. So, Source Qualifier happens when you drag a source to the mapping designer. Here’s our source: Here’s what happens whenContinue reading “Informatica Powercenter – Source Qualifier Trasformation”

Informatica Powercenter – Expression Transformation

First post of the many to be on Informatica Powercenter, starting right with Expression Transformation. In this scenario our goal is to get data from a flat file, transform it using expressions and then load into our database the result of that transformation. First, we need: a source, then a target, then this target needsContinue reading “Informatica Powercenter – Expression Transformation”