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

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

Answer Posted / vidyasagar

Dude Jay,

its a passive transformation

in yo case eventhough you are selecting first last or any
it will select the selected column and null for the rest of
the rows so the number of rows remains same , hence its the
passive transformation.

one more thing you can by-pass the lookup so only a passive
txn can be by-passed.

if anyone have any queries lemme know :)

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain pmcmd command usage in informatica

1064


Why do we need informatica?

925


Can we create a node as a gateway node and the same node can be assigned to a grid?

1025


What is a pre-defined event and user-defined event?

971


What do mean by local and global repository?

1150


What is a repository manager?

1029


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1032


How is union transformation utilized?

948


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2676


what are the deliverables?in your project?

2084


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1726


hi real timers . iam waiting for ur reply regarding ETL TESTING

2206


How we can create indexes after completing the loan process?

1141


How to update source definition?

1030


Write the unconnected lookup syntax and how to return more than one column.

1048