Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / narender.vankuri

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

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

what is filelist concept in informatica

4 Answers  

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

Can you use flat files in Mapplets.

0 Answers  

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

How to elaborate powercenter integration service?

0 Answers  

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

Name 4 output files that informatica server creates during session running?

1 Answers  

How can repository reports be accessed without sql or other transformations?

0 Answers  

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories