when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
- 5 Answers
- 15191 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 |
What is the difference between informatica 8.x and 9.x
what is target load plan
What is a passive transformation?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
What is a filter transformation and why it is an active one?
what are the challenge face in u r project?explain me
What are the informatica performance improvement tips
How you count the number of records available at your source?
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
Teradata 
