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 […]
Read MoreTag: Mapping
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 […]
Read MoreHow 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 […]
Read MoreHow 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 […]
Read MoreHow 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 […]
Read MoreInformatica Target Load Plan
Target Load Group and Target Load Plan If you have multiple Source Qualifier transformations connected to multiple targets, you can specify the order in which the Integration Service loads the data […]
Read MoreHow 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 […]
Read MoreHow to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented
[Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented You may get this error while trying to Preview data on Target in a Mapping Designer. I have also seen the […]
Read MoreSource Qualifier – Full Outer Join
Full Outer Join using Source Qualifier – ‘SQL Query’ Integration service support only Left & Right outer joins. We cannot perform Full outer join using ‘User Defined Join’ properties in […]
Read MoreSource Qualifier – User Defined Join – Right Outer Join
How to join two tables – Source Qualifier – User Defined Join – Right Outer ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database […]
Read MoreSource Qualifier – User Defined Join – Left Outer Join
How to join two tables – Source Qualifier – User Defined Join – Left Outer ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database […]
Read MoreSource Qualifier – User Defined Join – Normal Join
How to join two tables – Source Qualifier – User Defined Join ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database ** There are […]
Read MoreJoiner 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 […]
Read MoreJoiner 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 […]
Read MoreMapping 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 […]
Read More