Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11729 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 differentiate between the active and passive transformations?
Define filter transformation?
What is a filter transformation?
How union transformation is used?
can u give example for factless fact table
Name the different lookup cache(s)?
What is main use of mapplet?
What can we do to improve the performance of informatica aggregator transformation?
How to generate sequence numbers using expression transformation?
How to join three sources using joiner?
Where is metadata stored?
how to load rows into fact table in data warehouse
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How do you set a varible in incremental aggregation
Difference between Data and Index Caches?
