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
- 10760 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 unit testing in informatica? How to load data in informatica ?
What is olap (on-line analytical processing?
how to load dimension table and fact table. plz tell me the steps.
What is pmcmd command?
State the limitations where we cannot use joiner in the mapping pipeline?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is the use of code page?
Briefly define reusable transformation?
Explain sql transformation in script mode examples in informatica
What is workflow monitor?
How to create the source and target database connections in server manager?
Explain pushdown optimization and types in informatica
How to use procedural logic inside infromatica?
How many numbers of sessions can one group in batches?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
