Interested to Buy Any Domain ? << Click Here >> for more details...
What are the active and passive transforamtions?
- 2 Answers
- 7536 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 |
how can one come to know wether the records loak into the target if we use update strategy
How many mapplets u have created? and what is the logic used
write a query to get maximum salary from the employers table without duplicates....kindly help me
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is main use of mapplet?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What can we do to improve the performance of informatica aggregator transformation?
What is router transformation
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
Can we create multiple integration service on single repository?
Filter transformation in the condition one of the data is NULL would the record be dropped.
Teradata 
