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 MoreTag: Mapping
Informatica Sorter Transformation Overview
Sorter Transformation Overview # To sort data in ascending or descending order. # Can sort data from relational or flat file sources. # The Sorter transformation contains only input/output ports. […]
Read MoreInformatica Filter Transformation
Filter transformation – Part 1 Use the Filter transformation to filter out rows in a mapping. As an active transformation, the Filter transformation may change the number of rows passed […]
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 MoreHow 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 […]
Read More