What are the active and passive transforamtions?
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 do you join more than 3 flat files in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the types of data that passes between informatica server and stored procedure?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
What are the designer tools for creating tranformations?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
What is informatica?
expain about the tune parameters?
What is standalone command task?
How many numbers of sessions can one group in batches?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?