Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 25752 Views
- I also Faced
- E-Mail Answers
Answer Posted / parveen kumar
The imp. diff b/w connected and unconnected lookup is regarding to their performance. Suppose if a lookup condition is true only for one thousand rows out of 1M rows. Then we must use unconnected lookup in such cases by calling the lookup only in else condition i.e. we can write in EXP that if ID(suppose this is I/N port)is null, then -1 else :LKP.(lookup transformation name). So in this case, it'd hit the DB only 1000 times. But if we use connected lookup, it'd hit the DB 1M times no matter whether the condition is true or not.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make Data masking in informatica..
can we override a native sql query within informatica? Where do we do it?
Explain the features of connected and unconnected lookup.
What are the advantages of informatica?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Why do you use Mapping Parameter and mapping variable?
How would you copy the content of one repository to another repository?
What are the types of lookup transformation?
What is the difference between a connected look up and unconnected lookup?
What is the different lookup cache(s)?
Explain lookup transformation is active in informatica
What do you mean by blocking transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is a filter transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
