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… Continue reading Joiner Transformation – Normal Join
Tag: Informatica
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… Continue reading Joiner Transformation Overview
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… Continue reading Mapping with Sorter Transformation
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… Continue reading Aggregator Transformation Overview
How to Join multiple tables without Joiner Transformation
How to Join multiple tables without Joiner Transformation Lets see one scenario, how to join two tables without using Joiner Transformation. This can be achieved by just using Source Qualifier –… Continue reading How to Join multiple tables without Joiner Transformation
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… Continue reading How to Download and extract Informatica Installation Files 9.6.1 – Multi Volume Zip files
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… Continue reading How to Download and Install Informatica 9.6.1
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… Continue reading Informatica Filter Transformation
Source Qualifier Transformation – My First Mapping
Source Qualifier Transformation – My First Mapping This is my first mapping after my informatica installation in Windows 7. This session will cover 1. How to add a Oracle data… Continue reading Source Qualifier Transformation – My First Mapping
How to create source & target connections in session
How to create source & target connections in session If you are creating a session for the first time you mght not see any connections listed in the session properties.… Continue reading How to create source & target connections in session
How to create connections in Oracle SQL developer
Create User & connections in Oracle SQL developer You should create at least one database user that you will use to create database objects. Here i created a database connection… Continue reading How to create connections in Oracle SQL developer
Informatica – Working with Delimited Flat Files
Informatica – Working with Tab Delimited Flat Files Source : Tab delimited Flat file Target : Oracle Table Create a target table, here its a oracle table with same layout… Continue reading Informatica – Working with Delimited Flat Files
Informatica – Working with Fixed Width Flat Files
Informatica – Importing Fixed Width Flat Files — Fixed-width flat files are byte-oriented (measured in bytes). — It can also be line sequential, which means each row ends with a… Continue reading Informatica – Working with Fixed Width Flat Files
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… Continue reading TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points
How to concatenate the first and last name – Expression Transformation
Informatica – How to concatenate the first and last name – Expression Transformation Using expression transformation we can combine two strings to a single string and load to target. Here… Continue reading How to concatenate the first and last name – Expression Transformation