Answer Posted / saral mariyaprakasam
The active transformation can change the rows pass
through by it. The passive transformation can not make the
changes the rows pass through by it.
The active transformations are aggregator, application
source qualifier, custom, filter,joiner, Normalizer, rank,
router,sorter,source qualifier, transaction control,union,
update strategy,XML parser,XML source qualifier
transformations.
The passive transformations are custom,expression,
external procedure,input,lookup,output,sequence generator,
stored procedure transformations.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a node in Informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the prerequisite tasks to achieve the session partition?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is the use of code page?
What is a repository manager?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is fact table? Explain the different kinds of facts.
lookup transformation with screenshots
What is meant by target load plan?
What is the need of etl tools?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is decode in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
