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

Hi Experts,

Performance Wise Which transformation is better in LOOKUP
AND JOINER TRansformations? Why? Can anybody please explain
it ?
Please help me out from this Question.

Thanks In Advance.

Question Posted / krishna213666

Answers were Sorted based on User's Feedback



Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformation..

Answer / sukanta

Look up will better perform because the cache is initially
created when the first record will reach at Look up
tarnsformation and the further records are work upon the
cached records.Look up will perfrom left outer Join
only.Other Joins can't be posible.You can check the records
are either exists in the lookup table or not.

Jioner will be slower than look up but sorted port
Join,well choosing of Master and detail configuration will
give better performance for Joiner.

Is This Answer Correct ?    7 Yes 3 No

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformation..

Answer / raj

the lookup and joiner t/r can be used to join two sources data.
if u r using one source is flat file and another source is database source then we can use joiner is better.i.e heterogeneous join.it is not possible with the help of lookup.
if two sources are in the same database lookup is better.

Is This Answer Correct ?    5 Yes 10 No

Post New Answer

More Informatica Interview Questions

What are the types of lookup transformation?

0 Answers   Informatica,

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

How can u stop a batch?

2 Answers  

Explain what are the different types of transformation available in informatica.

0 Answers  

normalizer transformation

3 Answers   CTS,

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

How to display First letter of Names in Caps?

7 Answers  

For more Informatica Interview Questions Click Here
Categories