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

what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).

Answer Posted / akash

In addition to Kondeti's points:
1. With look up we have an option to match the data
dynamically if we use dynamic lookup.
2. If the match is not found may or may not send the record
(depending upon the joiner condition) but in case of look
up the output will be returned as default value or NULL for
every record where match is not found.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to create multiple domains on a single Informatica server?

1183


permutations of mapplet

2456


Design a mapping to load the cumulative sum of salaries of employees into target table?

1424


What is a joiner transformation and why it is an active one?

1000


can u any challenge your project?

1974


Why union transformation is an active transformation?

997


What is rank index in rank transformation?

1013


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

1028


waht type of interface is used for testing the data in informatica

2195


Differences between version 7.x and 8.x.

1843


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2353


What is a router transformation?

1050


What are the new features of Power Center 5.0?

1702


how to load dimension table and fact table. plz tell me the steps.

2039


How to Create a folder using pmrep command?

1107