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?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Which is costliest transformation? costly means occupying more memory?
Which transformation should u need while using the cobol sources as source defintions?
Do you have knowledge in ralph kimball methodology
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
What is Collect performance data in informatica and what is the use of it.
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
What could be the possible resons of locks by user?
What is the difference between writing a joiner query in ANSI style and THETA style?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to run a session, which contains mapplet?