Home » Informatica – How to

How to start a workflow using pmcmd

PowerCenter provides a number of command line programs that you call from your application to manage the Integration Service and Repository Service. What is ​pmcmd? pmcmd​ ​is a command line programs that can be used to manage workflows….

Read More »

How To Propagate Port Attributes

Propagating Port Attributes When you edit a port name in a transformation, by default, the Designer propagates references to that port in the expressions, conditions, and other ports in that transformation. You can also propagate changed attributes throughout…

Read More »

How to Convert Julian to Gregorian date in Informatica

How to Convert Julian date to Gregorian date in Informatica Dates in the Julian calendar are called Julian dates which are not supported in Informatica. We need to convert the date to Gregorian calendar for further informatica processing….

Read More »

How to remove duplicate records using Sorter Transformation

How to remove duplicate records using Sorter Transformation In the last two post we have seen how to remove duplicate records (Only one column) using Aggregator and Expression. We have identified the duplicate JOB_ID and skipped those rows…

Read More »

How to load every 5th record into target table

How to load every 5th record into target table We need to read the source table and load only 1st and every 5th (nth) records to target. Let’s start the mapping for this. We need a sequence generator and…

Read More »

How to remove duplicate records using Expression

How to remove duplicate records using Expression In the last post we have used Aggregator Transformation to remove the duplicate records. In this post we will use the Expression transformation to remove the duplicate JOB_ID from the source Flat…

Read More »

How to remove duplicate records Using Aggregator

How to remove duplicate records Using Aggregator There are couple of options available in informatica to remove duplicate records from the source.  For Relational Tables 1. Source Qualifier > ‘SELECT DISTINCT’ option 2. Source Qualifier > SQL override…

Read More »

How to Load only Half of the records from Source table

Load only Half of the records from Source table The requirement is to process only half of the records from the source table. To do this we need to calculate the total number of rows (TOTAL-COUNT) in the source…

Read More »

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

Read More »

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

Read More »

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

Read More »

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

Read More »

How to unlock HR sample account in oracle 11G express edition

How to Unlock HR sample account in oracle 11G express edition This session will cover how to unlock HR sample account in oracle 11G express edition. Here is the steps to follow … 1. Go to CMD (Command Prompt)…

Read More »