Lesson 12 — Informatica SORTER Transformation | ORDER BY vs SORTER | Unique Records & Cache

Описание: In this session, we learn the Sorter Transformation in Informatica PowerCenter and how it is used to sort data in ETL pipelines — just like ORDER BY in SQL.
We also understand how to send unique records to target using Sorter and Aggregator logic, and learn important performance rules & interview points.

✅ What You Will Learn

What is Sorter Transformation?

ORDER BY vs SORTER (Oracle vs Informatica)

DISTINCT option in Sorter — internal behavior

How Sorter becomes an Active Transformation

Sorter Cache — execution mechanism

How to remove duplicates in ETL

SORTER vs AGGREGATOR for unique records

Real-time ETL + Interview concepts explained