Interested to Buy Any Domain ? << Click Here >> for more details...
What are the active and passive transforamtions?
- 2 Answers
- 7412 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / swetha
An active transforamtion can change the number of rows that
pass through it.
A passive transformation does not change the number of rows
that pass through it.
| Is This Answer Correct ? | 1 Yes | 0 No |
why we use informatica in our project?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
Limitation of REPLACESTR. Is there any character limitation to it.
How can yoU improve session performance in aggregator transformation?
All active transformations r passive or not?
what is the architecture of any Data warehousing project?
How you can differentiate between connected lookup and unconnected lookup?
If we have lookup table in workflow how do you trouble shhot to increase performance?
Mapplets can you use an active transformation in a mapplet,
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Where can we find the throughput option in informatica?
What is the difference between OLTP and ODS?
Teradata 
