When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
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 |
What are mapplets?
What is an incremental loading? in which situations we will use incremental loading
scenario where i can use only concurrent execution of workflow.
What are mapping parametres and variables in informatica?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
What are parallel querys and query hints?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
how to improve performence by using sorted input in aggrigator t/r.
performance tuning of Informatica
when we use dynamic lookup,if condition matches what will be the o/p?