Answer Posted / atiric softwares(raja)
An active transformation can change the no. of rows that
passes through it eg: filter transformation passes the rows
from the source to target that which meet the filter condition.
an passive transformation cannot change the rows that which
passes through it eg: an expression transformation that
performs the calculation on the data and passes all the rows
from source to target
| Is This Answer Correct ? | 25 Yes | 2 No |
Post New Answer View All Answers
without table how to come first record only in oracle?
What is fact table? Explain the different kinds of facts.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is a joiner transformation and why it is an active one?
What are different types of transformations available in informatica?
Sequence generator, when you move from develoment to production how will you reset
what is song in infrmatica...?
What are the main issues while working with flat files as source and as targets ?
How can we store previous session logs?
How can we use mapping variables in informatica? Where do we use them?
Differences between connected and unconnected lookup?
Where are the source flat files kept before running the session?
What is an expression transformation in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use