Informatica: Separation of Duplicate & Non-Duplicate values
In this tutorial, you'll learn how to separate duplicate and non-duplicate values to different target files from source file.
Informatica PowerCenter, the flagship tool of Informatica works on basis of transformations which transform data in multiple ways.
Types of transformations[edit]
Active : One that can change the number of rows being output.
Passive : One that cannot change the number of rows being output.
Transformations examples[edit]
Source qualifier - conversion of source datatypes to Informatica datatypes
Expression - transforming data with functions
Lookups - joining data with lookups
Sorter & Aggregator - sorting and aggregating data
Update Strategy expressions
Transaction control - how to create transactions and control commits and rollbacks
Java transformation - invoking Java methods, variables, third-party API's and built-in packages with Java transformation
