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

What's the layout of parameter file (what does a parameter file contain?)?

1917


How to load last n records of file into target table - informatica

600


What is a snowflake schema?

573


Did u used latest transformations of 8.6.0? for what?

1481


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055






Under what condition selecting sorted input in aggregator may fail the session?

667


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1874


Why update strategy and union transformations are active? Explain with examples.

716


What is a repository? And how to add it in an informatica client?

664


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1692


Can we create multiple integration service on single repository?

705


How identifying bottlenecks in various components of informatica and resolving them?

587


What is rank transformation?

583


Explain the different lookup methods used in informatica?

590


What are pre and post-session shell commands?

746