Informatica: Load first, last & in-between records

In this tutorial, you'll learn how to Load first, last & in-between records from source to target.

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