What is active and passive transformation?

Answer Posted / malli

Active is a no of rows can change pass through it, and

Passive is can not change the no of rows pass through it.

eg: filter transformation passes the rows
from the source to target that which meet the filter condition.

eg: an expression transformation that
performs the calculation on the data and passes all the rows
from source to target

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly define a session task?

588


What is the function of aggregator transformation?

573


What is persistent lookup cache?

598


4 yrs etl devloper roles and responsibilities?any body give solutions

1567


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1638






In warehouses how many schemas are there?

577


What is workflow manager?

571


Explain load alternative records / rows into multiple targets - informatica

678


What is target designer and target load order?

652


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1533


What is transformation?

655


Is stop and abort are same in informatica?

568


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1744


Enterprise data warehouse your projects phase by phase explain?

1456


Explain lookup transformation in informatica

642