Tag: Informatica

Joiner Transformation Overview

No Picture

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…

Read More »

Mapping with Sorter Transformation

No Picture

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…

Read More »

Aggregator Transformation Overview

No Picture

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…

Read More »

How to Join multiple tables without Joiner Transformation

No Picture

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 – ‘User Defined Join’ property. Here we are going to…

Read More »

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

No Picture

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…

Read More »

How to Download and Install Informatica 9.6.1

No Picture

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…

Read More »

Informatica Filter Transformation

No Picture

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…

Read More »

Source Qualifier Transformation – My First Mapping

No Picture

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 source 2. How to create mapping with Source…

Read More »

How to create source & target connections in session

No Picture

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. You need to add the connections in the…

Read More »

How to create connections in Oracle SQL developer

No Picture

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 (ORACLEXE) for the SYSTEM user. Now I am…

Read More »

Informatica – Working with Delimited Flat Files

No Picture

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 as source file Start the job and review…

Read More »

Informatica – Working with Fixed Width Flat Files

No Picture

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 newline character. — Use Flat File Wizard to…

Read More »

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

No Picture

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…

Read More »

How to concatenate the first and last name – Expression Transformation

No Picture

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 we are going to concatenate First Name &…

Read More »

PCSF_46008 Cannot connect to domain to lookup service

No Picture

Informatica – PCSF_46008 Cannot connect to domain to lookup service You may experience this error while trying to connect to PowerCenter developer tools like Repository Manager, Designer, workflow Manager or workflow monitor. This error might be due to…

Read More »