Tag: Source Qualifier

Informatica Target Load Plan

No Picture

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 into the targets using ‘Target Load Plan’. This…

Read More »

Source Qualifier – Full Outer Join

No Picture

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 SQ, you will get a database error. This…

Read More »

Source Qualifier – User Defined Join – Right Outer Join

No Picture

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 ** There are two options available in SQ…

Read More »

Source Qualifier – User Defined Join – Left Outer Join

No Picture

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 ** There are two options available in SQ…

Read More »

Source Qualifier – User Defined Join – Normal Join

No Picture

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 two options available in SQ to join multiple…

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 »

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 »

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 »