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

Have you worked with/created Parameter file

1614


What is the difference between informatica 7.0 and 8.0?

954


Write the program through which the records can be updated?

938


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1994


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

1011


How does a rank transform differ from aggregator transform functions max and min?

1147


What is meant by active and passive transformation?

1031


What is the meaning of up gradation of repository?

1899


How many dimensions are there in informatica?

1025


In informatics server which files are created during the session rums?

1066


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7267


Explain lookup transformation is active in informatica

1038


What are the types of lookup transformation?

1025


What is event and what are the tasks related to it?

1057


What if the source is a flat-file?

1045