Update Strategy Transformation – My Notes How rows are flagged for insert, update, delete, or reject within a mapping? Ans:- Using Update Strategy transformation. We can also use the Custom… Continue reading Informatica certification – Update Strategy Transformation
Author: kvt
Informatica certification – Aggregator Transformation
Aggregator Transformation – My Notes What is the use of Aggregator Transformation? Ans:- Aggregator transformation can be used to aggregate calculations (Avg, Sum, Max ..) on groups. Since its changing… Continue reading Informatica certification – Aggregator Transformation
Informatica certification – Transformations
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… Continue reading Informatica certification – Transformations
Informatica certification – Lookup Transformation
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… Continue reading Informatica certification – Lookup Transformation
How to remove duplicate records using Sorter Transformation
How to remove duplicate records using Sorter Transformation In the last two post we have seen how to remove duplicate records (Only one column) using Aggregator and Expression. We have… Continue reading How to remove duplicate records using Sorter Transformation
How to load every 5th record into target table
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… Continue reading How to load every 5th record into target table
How to remove duplicate records using Expression
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… Continue reading How to remove duplicate records using Expression
How to remove duplicate records Using Aggregator
How to remove duplicate records Using Aggregator There are couple of options available in informatica to remove duplicate records from the source. For Relational Tables 1. Source Qualifier > ‘SELECT… Continue reading How to remove duplicate records Using Aggregator
Informatica Certification – My Notes
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… Continue reading Informatica Certification – My Notes
Informatica Certification Developer Specialist
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… Continue reading Informatica Certification Developer Specialist
Informatica Target Load Plan
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… Continue reading Informatica Target Load Plan
How to Load only Half of the records from Source table
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… Continue reading How to Load only Half of the records from Source table
How to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented
[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… Continue reading How to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented
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… Continue reading Source Qualifier – Full Outer Join
Source 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… Continue reading Source Qualifier – User Defined Join – Right Outer Join