Joiner Transformation – Normal Join

Joiner Transformation – Normal Join Let’s create a Mapping with a Joiner Transformation – Normal Join. We are going to join two tables JOB_ID1 & JOB_ID2 and create a target with the ports from two tables. Normal Join With a normal join, the Integration Service discards all rows of data from the master and detail […]

Read More

Joiner Transformation Overview

Joiner Transformation Overview 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 a condition that matches one or more pairs […]

Read More

Mapping with Sorter Transformation

Mapping with Sorter Transformation # To sort data in ascending or descending order. # Can sort data from relational or flat file sources. # The Sorter transformation contains only input/output ports. # All data passing through the Sorter transformation is sorted according to a sort key. # The sort key is one or more ports […]

Read More

Aggregator Transformation Overview

Aggregator Transformation Overview  The Aggregator transformation performs aggregate calculations, such as average, Sum, Max & Min etc. The Aggregator is an active transformation that changes the number of rows in the pipeline. The Integration Service performs the aggregate calculation on groups. The Integration Service then passes the last row received, along with the results of the aggregation. […]

Read More

How to Download and extract Informatica Installation Files 9.6.1 – Multi Volume Zip files

Download and extract Informatica Installation Files  Go to https://www.oracle.com/downloads/index.html and download all informatica files. There are 4 zip files in this package. These are multi volume zip files, we need to extract all files to a single folder and then extract only the base zip file, it will automatically extract from all other zip volumes […]

Read More

How to Download and Install Informatica 9.6.1

Download & Install Informatica 9.6.1 In this session we will cover how to install Informatica powerCenter server & client and make it ready for your first mapping. Download Informatica Installation files from oracle.com #Use WinRAR to unzip the multi volume zip files or else you may get error while extracting. # Check out the post How […]

Read More

Informatica Filter Transformation

Filter transformation – Part 1 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 that do not meet the condition. […]

Read More

TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points

TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points. Your session may fail with this error while doing aggregator transformation with ‘Sorted Input’ enabled. This is not a data Issue but a configuration Issue. We need to add a custom property (AggSupprtWithNoPartLic = YES) in the PowerCenter integration service to […]

Read More