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

how lookup is acting as both active and passive ?
how is it possitble?

Question Posted / eswar

Answer Posted / eswar

Both Lookup transformations are passive

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

And

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

Therefore, the Lookup transformations work as passive but
not as active transformations.

Is This Answer Correct ?    7 Yes 26 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1988

What will be the approach?

1038

How can we use mapping variables in informatica?

1124

What is informatica etl tool?

1060

How many types of sessions are there in informatica.please explain them?

1210

What is dimensional table?

1131

What is target designer and target load order?

1170

State the limitations where we cannot use joiner in the mapping pipeline?

1106

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7235

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108

What is status code in informatica?

1064

How can one identify whether mapping is correct or not without connecting session?

1497

What are the types of schemas we have in data warehouse.

1004

How to create the source and target database connections in server manager?

1131

how to create user defined function (udf) in informatica

1350