Interested to Buy Any Domain ? << Click Here >> for more details...
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
- 5 Answers
- 8831 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rascal
connected lookup is used when we need to use dynamic cache,we can return multiple o/p&need to use default values...otherwise if we want to use same lookup multiple times in the mapping then we go for un-connected lookup..In this case we can use only static cache..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / poluraju
u return multiple ports you can choose connected lookup.if u want to return only one port u can choose connected or unconnected lkp.but if we want to call the same lookup multiple time with different input for single row then we choose unconnected lkp...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sandy
Connected Lookup :- When we require more than one row to be
output from the lookup.
UnConnected Lookup:- When we need only one port as output
from the lookup
| Is This Answer Correct ? | 1 Yes | 2 No |
When we want to return multiple ports from a mapping we wil
use connected lookup.
An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)
regards,
rayudu
| Is This Answer Correct ? | 2 Yes | 3 No |
i have 2 session s1 execute s2 load first session fail what is the reason?
How to send duplicates to one target and unique rows to one target?target is empty
Why we use lookup transformations?
What is Data Caches size?
What are the two modes of datamovement in informatica sever?
how to get the first row without using rank t/r?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
what are the challenge face in u r project?explain me
What is log file,and where is it located,why u r using the log file
What are multi-group transformations?
What does command task mean?
Teradata 
