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.… Continue reading How to Join multiple tables without Joiner Transformation
Category: Informatica
How 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… Continue reading How to Download and extract Informatica Installation Files 9.6.1 – Multi Volume Zip files
How 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… Continue reading How to Download and Install Informatica 9.6.1
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. # All data passing through the Sorter transformation is sorted according to a sort key. # The sort key is one or more ports that… Continue reading Informatica Sorter Transformation Overview
Informatica 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.… Continue reading Informatica Filter 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 source 2. How to create mapping with Source Qualifier 3. How to add Source & target database connection in session level 4. How to create… Continue reading Source Qualifier Transformation – My First Mapping
How 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… Continue reading How to create source & target connections in session
How 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… Continue reading How to create connections in Oracle SQL developer
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 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… 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 newline character. — Use Flat File Wizard to create, move, or delete column breaks. — ‘Start Import At Row’ Indicates the row number at which… Continue reading Informatica – Working with Fixed Width Flat Files
TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points
TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points. Your session may fail with this error while doing aggregator transformation with ‘Sorted Input’ enabled. This is not a data Issue but a configuration Issue. We need to add a custom property (AggSupprtWithNoPartLic = YES) in the PowerCenter integration service to… Continue reading TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points
How 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 we are going to concatenate First Name & Last name and storing to a new column in target as Full Name using CONCAT function in… Continue reading How to concatenate the first and last name – Expression Transformation
PCSF_46008 Cannot connect to domain to lookup service – Informatica power center
You may experience this error while trying to connect to PowerCenter developer tools like Repository Manager, Designer, workflow Manager or workflow monitor. This error might be due to below two possible scenarios. Your informatica service is not running your database connection password might have expired Here is the steps to follow to make sure… Continue reading PCSF_46008 Cannot connect to domain to lookup service – Informatica power center
PowerCenter Express Overview
PowerCenter Express Overview — Its a single unified enterprise data integration platform. — Use PowerCenter Express to design and implement data integration solutions. — Use it to extract data from multiple sources, transform the data according to business logic, and load the transformed data to targets. (ETL) — PowerCenter Express includes the Informatica domain, clients, server and… Continue reading PowerCenter Express Overview
Informatica Transformations – Types
Types of Transformations A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data. Transformations in a mapping represent the operations the Integration Service performs on the data. Transformations can be of the… Continue reading Informatica Transformations – Types