Tag: Informatica

Informatica services stops automatically

No Picture

Informatica Services are Getting Stop Automatically All of a sudden i couldn’t connect to Repository, I am getting an error. Usually this error comes if the Informatica service is not running. I tried to restart the service in…

Read More »

Informatica certification – Transformations

No Picture

Working with Transformations – My Notes — Transformation Overview —  Which is the repository object that generates, modifies, or passes data? Ans:- A Transformation. Which transformation performs calculations on groups of data? Ans:- Aggregator Transformation. What are the…

Read More »

Informatica certification – Lookup Transformation

No Picture

Lookup Transformation – My Notes What is Lookup transformation? Ans:- It can be used to look up data in a flat file, relational table, source Qualifier, view, or synonym. What are the various tasks can be performed by…

Read More »

How to load every 5th record into target table

No Picture

How to load every 5th record into target table We need to read the source table and load only 1st and every 5th (nth) records to target. Let’s start the mapping for this. We need a sequence generator and…

Read More »

How to remove duplicate records using Expression

No Picture

How to remove duplicate records using Expression In the last post we have used Aggregator Transformation to remove the duplicate records. In this post we will use the Expression transformation to remove the duplicate JOB_ID from the source Flat…

Read More »

Informatica Certification – My Notes

No Picture

The below question and answers are my preparation notes for Informatica Developer Specialist certification which I am planning to take some time in June. I will continue update this page as i go through various topics as per syllabus. Just…

Read More »

Informatica Certification Developer Specialist

No Picture

PowerCenter Data Integration 9.x: Developer, Specialist Certification This is Skill set Inventory document from Oracle website. Here you will get all the information which is required for the Informatica certification Perspective. About the Informatica Certified Professional (ICP) Program…

Read More »

Informatica Target Load Plan

No Picture

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 into the targets using ‘Target Load Plan’. This…

Read More »

How to Load only Half of the records from Source table

No Picture

Load only Half of the records from Source table The requirement is to process only half of the records from the source table. To do this we need to calculate the total number of rows (TOTAL-COUNT) in the source…

Read More »

How to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented

No Picture

[Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented You may get this error while trying to Preview data on Target in a Mapping Designer. I have also seen the same error from Source Qualifier Transformation while applying…

Read More »

Source Qualifier – Full Outer Join

No Picture

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 SQ, you will get a database error. This…

Read More »

Source Qualifier – User Defined Join – Right Outer Join

No Picture

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 ** There are two options available in SQ…

Read More »

Source Qualifier – User Defined Join – Left Outer Join

No Picture

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…

Read More »

Source Qualifier – User Defined Join – Normal Join

No Picture

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…

Read More »

Joiner Transformation – Normal Join

No Picture

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…

Read More »