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
- 11689 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
According to his methodology what all you need before you build a datawarehouse
What is informatica?
How an expression transformation differs from aggregator transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the need of an ETL tool?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What could be the possible resons of locks by user?
What are the types of caches in lookup?
What is a rank transform?
Explain lookup transformation source types in informatica
Explain pushdown optimization $pushdownconfig parameter - informatica
How would you join a node to the already existing domain?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Which transformation should we use to normalise the COBOL and relational sources?
What is pmcmd command?
