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

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

Answer Posted / krishna

joiner is best because we will make less number of records or dublicate records as master. integration servic create cahce for master table. becaue of that cahce size is small and secarching oricess become easy. in case of lookup its should scane om botom to end it will take more time.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

permutations of mapplet

2548


what is unit testing?tell me proceedure

2274


How would you join a node to the already existing domain?

1180


How can we handle two sessions in informatica?

1092


Differentiate between a database and data warehouse?

1192


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7370


What are the types of caches in lookup?

1094


Sequence generator, when you move from develoment to production how will you reset

2123


What is a joiner transformation?

1035


Write the unconnected lookup syntax?

1131


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2104


Performance tuning in UNIX for informatica mappings?

2623


In informatica workflow manager, how many repositories can be created?

1437


How we can create indexes after completing the load process?

1199


How do you convert single row from source into three rows into target?

1212