Interested to Buy Any Domain ? << Click Here >> for more details...
when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
- 5 Answers
- 16202 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sweta kedia
A. Connected Lookup
Receives input values directly from the pipeline.
We can use a dynamic or static cache
Supports user-defined default values
Unconnected Lookup
Receives input values from the result of a :LKP expression
in another transformation.
We can use a static cache
Does not support user-defined default values
When you compared both basically connected lookup will
return more values and unconnected returns one value. conn
lookup is in the same pipeline of source and it will accept
dynamic caching. Unconn lookup don't have that faclity but
in some special cases we can use Unconnected. if output of
one lookup is going as input of another lookup this
unconnected lookups are favourable
Moreover if the mapping requires multiple lookup using same
lookup conditions then its better to use unconnected lookup
& call the lookup wherever required.This also prevents the
mapping from being complex.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / v.ramakrishna
when it comes to the matter of performance optimization we
can understand the diff between conn lookup and unconn
lookup y bcoz in conncted lookup it will give more than one
output. when compared with the performance of unconn lookup
it is some what slower bcoz the execution times in conn
lookup is equal with no of records present in source . so
it will increase running time . where as in unconn lookup
it executes only for records which satisfy the given
condition so no need to call lookup for each and every
record unneccesarily. so it leads to performance
development in unconn lookup compared wth conn lookup.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / nag
Connected Lookup
Receives input values directly from the pipeline.
We can use a dynamic or static cache
Supports user-defined default values
Unconnected Lookup
Receives input values from the result of a :LKP expression
in another transformation.
We can use a static cache
Does not support user-defined default values
When you compared both basically connected lookup will
return more values and unconnected returns one value. conn
lookup is in the same pipeline of source and it will accept
dynamic caching. Unconn lookup don't have that faclity but
in some special cases we can use Unconnected. if output of
one lookup is going as input of another lookup this
unconnected lookups are favourable
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / jeevan kumar medapati
if u want to perform look up on less values then we go for
connected lkp
if u want to perform look up from more than one table then
we go for un connected lkp
in ur source u have more date columns then we should go for
unconnected lkp.
| Is This Answer Correct ? | 1 Yes | 1 No |
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Please let me know how to make Data masking in informatica..
what is Partitioning ? where we can use Partition?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
Why do we need informatica?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to recover the standalone session?
Teradata 
