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



Source Qualifier is an active t/r but there is no change of row count then y should we called it a..

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

Source Qualifier is an active t/r but there is no change of row count then y should we called it a..

Answer / narender.vankuri

Thank u very much Ravindra

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,


Which is costliest transformation? costly means occupying more memory?

3 Answers  


Which transformation should u need while using the cobol sources as source defintions?

2 Answers  


Do you have knowledge in ralph kimball methodology

1 Answers  


In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  






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)

4 Answers  


What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,


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

5 Answers   IBM,


What could be the possible resons of locks by user?

0 Answers  


What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  


How to run a session, which contains mapplet?

1 Answers  


Categories