What are different types of transformations in Informatica?

Question

can you help me with this question

in progress 0
Aravind 2025-02-22T06:06:35+00:00 1 Answer 8 views
0

Answer ( 1 )

  1. Aravind
    0
    2025-02-22T06:09:29+00:00
    Reply

    Transformations modify data before loading it into the target. They are classified into:

    Active Transformations (Change row count)

    • Filter – Filters rows based on a condition.
    • Router – Sends data to multiple targets based on conditions.
    • Aggregator – Performs calculations like SUM, AVG, COUNT.
    • Rank – Selects top/bottom records.

    Passive Transformations (Do not change row count)

    • Expression – Performs calculations on row data.
    • Lookup – Retrieves values from a lookup table.
    • Sequence Generator – Generates unique numbers.

Leave an answer