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 MoreTag: 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 […]
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 MoreHow 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 – […]
Read MoreSource 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 […]
Read MoreInformatica – 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 […]
Read MoreInformatica – 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 […]
Read More