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… Continue reading Informatica Target Load Plan
Tag: Source Qualifier
Source 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… Continue reading Source Qualifier – Full Outer Join
Source 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… Continue reading Source Qualifier – User Defined Join – Right Outer Join
Source 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… Continue reading Source Qualifier – User Defined Join – Left Outer Join
Source 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… Continue reading Source Qualifier – User Defined Join – Normal Join
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
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
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