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 to join multiple tables, One using ‘User Defined join’ property and the other using ‘SQL Query’. We can […]
Read MoreCategory: Informatica PowerCenter
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 two options available in SQ to join multiple tables, One using ‘User Defined join’property and the other using ‘SQL Query’. We can create a join override […]
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 with the ports from two tables. Normal Join With a normal join, the Integration Service discards all rows of data from the master and detail […]
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 same source. The Joiner transformation joins sources with at least one matching column. The Joiner transformation uses a condition that matches one or more pairs […]
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 ports. # All data passing through the Sorter transformation is sorted according to a sort key. # The sort key is one or more ports […]
Read MoreAggregator Transformation Overview
Aggregator Transformation Overview The Aggregator transformation performs aggregate calculations, such as average, Sum, Max & Min etc. The Aggregator is an active transformation that changes the number of rows in the pipeline. The Integration Service performs the aggregate calculation on groups. The Integration Service then passes the last row received, along with the results of the aggregation. […]
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 – ‘User Defined Join’ property. Here we are going to join Two tables (EMPLOYEE & JOBS) and create a target table with columns from both the tables. […]
Read MoreHow to Download and extract Informatica Installation Files 9.6.1 – Multi Volume Zip files
Download and extract Informatica Installation Files Go to https://www.oracle.com/downloads/index.html and download all informatica files. There are 4 zip files in this package. These are multi volume zip files, we need to extract all files to a single folder and then extract only the base zip file, it will automatically extract from all other zip volumes […]
Read MoreHow to Download and Install Informatica 9.6.1
Download & Install Informatica 9.6.1 In this session we will cover how to install Informatica powerCenter server & client and make it ready for your first mapping. Download Informatica Installation files from oracle.com #Use WinRAR to unzip the multi volume zip files or else you may get error while extracting. # Check out the post How […]
Read MoreInformatica 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. # All data passing through the Sorter transformation is sorted according to a sort key. # The sort key is one or more ports that […]
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 through it. The Filter transformation allows rows that meet the specified filter condition to pass through. It drops rows that do not meet the condition. […]
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 source 2. How to create mapping with Source Qualifier 3. How to add Source & target database connection in session level 4. How to create […]
Read MoreHow to create source & target connections in session
How to create source & target connections in session If you are creating a session for the first time you mght not see any connections listed in the session properties. You need to add the connections in the workflow manager in order to show the list of connections in session level. Hope you have created […]
Read MoreHow to create connections in Oracle SQL developer
Create User & connections in Oracle SQL developer You should create at least one database user that you will use to create database objects. Here i created a database connection (ORACLEXE) for the SYSTEM user. Now I am going to create new users under SYSTEM connection. Here is the steps to follow … 1. Hope […]
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 as source file Start the job and review the session log, All 10 records were processed and loaded in to target. We are done, successfully […]
Read More