Source Qualifier is an active t/r but there is no change of
row count then y should we called it active t/r & Router ,
sorter some times no change in row count then Y we called
its active t/r?
- 2 Answers
- 11232 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravindra
A transformation is active does not mean that it always
change number of rows. An active transformation can have
passibility to change the number of rows.
In Source Qualifier we can do SQL-override to limit the
number of rows in whare condition, Sorter can remove the
duplicates when select the property checkbox Distinct, In
Router you can only extract the records from selected
(filtered) group. So the number of rows can be impacted.
Expression is an example for passive transformation. Never
change number of rows.
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
How to do the error handling of if ur source is flatfiles?
Explain the scenario which compels informatica server to reject files?
What are the databases that informatica can connect to windows?
What if the source is a flat-file?
What are the different ways to implement parallel processing in informatica?
pmscmd startworkflow -sv
What are the advantages of using informatica as an etl tool over teradata?
What will be the approach?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How do you change a non-reusable transformation to reusable transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the restrictions of union transformation?
How many dimensions are there in informatica?
generate date / time dimension in informatica
