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

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

What is rank transform?

0 Answers  

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

0 Answers  

Which kind of index is preferred in DWH?

3 Answers  

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

what is mapping performence?

2 Answers   Cap Gemini,

What is the meaning of decode in informatica?

0 Answers  

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

For more Informatica Interview Questions Click Here
Categories