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

when we go for unconnected lookup transformation? and why?

Answer Posted / suneel reddy

Answers 1:
Depending upon the scenario we use the conn and unconn tr..

for e.g
In u r mapping u require same lkp multiple times, creating
lkp multiple times put it in flow is not a good idea, which
occupies more cache ...
Instead of that create one unconnectes lkp use multiple
times where ever u want , which very fast..

Answers 2:
u can use conn lookup but if u need 1 row so go for unconn
lookup coz u can
use it multiple time in same mapping from multiple
expression trn.
i hope it will help to u

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define enterprise data warehousing?

1201


What is workflow monitor?

1059


Explain the scenario which compels informatica server to reject files?

1166


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

1122


How union transformation is used?

1004


How to extract sap data using informatica?

1042


What is union transformation?

963


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1900


How can we store previous session logs?

1075


How can we handle two sessions in informatica?

1030


can anyone explain me about retail domain project in informatica?

7946


How to do unit testing in informatica?

1171


difference between informatica 8.1.1 and 8.6

3677


Enlist some properties of sessions.

1065


How can we use mapping variables in informatica?

1061