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

What are the active and passive transforamtions?

Question Posted / swetha

Answers were Sorted based on User's Feedback



What are the active and passive transforamtions?..

Answer / saral mariyaprakasam

The active transformation can change the rows pass
through by it. The passive transformation can not make the
changes the rows pass through by it.
The active transformations are aggregator, application
source qualifier, custom, filter,joiner, Normalizer, rank,
router,sorter,source qualifier, transaction control,union,
update strategy,XML parser,XML source qualifier
transformations.
The passive transformations are custom,expression,
external procedure,input,lookup,output,sequence generator,
stored procedure transformations.

Is This Answer Correct ?    2 Yes 0 No

What are the active and passive transforamtions?..

Answer / swetha

An active transforamtion can change the number of rows that
pass through it.

A passive transformation does not change the number of rows
that pass through it.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is the location of parameter file in informatica?

1 Answers   TCS,

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

Write the different tools in the workflow manager?

0 Answers  

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

0 Answers  

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

in oracle write query yourname+1 from dual

5 Answers  

What is informatica worklet?

0 Answers  

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

WAT IS TEXT LOAD?

3 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories