Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 25481 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
What is depict expression change?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the new features of informatica 9.x in developer level?
Explain the etl program with few examples.
Parameter and variable differences
4 yrs etl devloper roles and responsibilities?any body give solutions
How to generate sequence numbers?
Difference between Data and Index Caches?
What is the way to execute pl/sql script using informatica mapping?
Scheduling properties,whats the default (sequential)
what is Active lock explain
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the different lookup cache(s)?
How to load data in informatica ?
What are the advantages of using informatica as an etl tool over teradata?
