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...


I still need further explanation about the difference
between active and passive transformation with some
examples.Thank You

Answers were Sorted based on User's Feedback



I still need further explanation about the difference between active and passive transformation wi..

Answer / murali krishna

Transformations can be active or passive.

- An active transformation can change the number of rows
that pass through it, such as a Filter transformation that
removes rows that do not meet the filter condition.

- A passive transformation does not change the number of
rows that pass through it, such as an Expression
transformation that performs a calculation on data and
passes all rows through the transformation.

Is This Answer Correct ?    11 Yes 1 No

I still need further explanation about the difference between active and passive transformation wi..

Answer / saradhi

Active Transformation means the no of records u got from
source table is filtred by the transformation and got only
few records may or may not at the target table so this an
active transforamtion. example: if u filtered the data by
agreegate function like sum(sal) here u got only one column
as output so its an active.
Passive means the no of records u got from source table is
equal to the target table records even though the
transforamtion is done
example: sal+comm here u got same no of records as source
after filtering also.

Is This Answer Correct ?    3 Yes 0 No

I still need further explanation about the difference between active and passive transformation wi..

Answer / soujanya

if all source records sends to target or for further
processing using any tranformation then the output is same
as source no. of records then it is passive transformation.
otherwise it is active

source no of records = target no. of records(passive)

source no. of records!=target no. of records(active)

Is This Answer Correct ?    1 Yes 0 No

I still need further explanation about the difference between active and passive transformation wi..

Answer / v.ramakrishna

In active trnasformation no of records extracted as input
can be vary with no of records come as output. where as in
active transformation no of records extracted as input
cannot vary with no of records comes out as output that
means no filteration according to no of records in passivi
transformation

Is This Answer Correct ?    0 Yes 0 No

I still need further explanation about the difference between active and passive transformation wi..

Answer / srinu

passive transformation :
unable to keep a condition,Expressions only.

active transformation :
unable to keep a Expressions,condition only.

Based on Transformation functionality.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

which one is better either active or passive transformation in informatica

1 Answers  


Repository user profiles

0 Answers  


What is data merging,data cleansing,sampling?

4 Answers  


If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,


What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  


What are the methods for creating reusable transforamtions?

2 Answers  


What are the designer tools for creating transformations?

0 Answers   Informatica,


how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,


how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,


How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,


what is bridge tables in informatica

1 Answers   CTS,


What are the new features of Power Center 5.0?

0 Answers  


Categories