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

which is better perfomancewise lookup or joiner and why?can anyone give example?

Answer Posted / m.m.basha

performwise both (connected& unconnected) are best
connected lookup :-it is connected to the source
unconnected loockup:- it is not connected to the source

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2132


Explain pmcmd command usage in informatica

1108


Performance tuning( what you did in performance tuning)

1960


Write the advantages of partitioning a session?

1259


whats the logic to load the lower level of granularity of data to fact table.

2255


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4095


What is incremental aggregation?

1062


Enterprise data warehouse your projects phase by phase explain?

1906


Name the different lookup cache(s)?

1214


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1890


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1679


Explain sessions?

1035


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

1025


What are the tasks that source qualifier perform?

1089


What is workflow? What are the components of the workflow manager?

1107