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 |
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What the difference is between a database, a data warehouse and a data mart?
How does a sorter cache works?
how did u understand business requirement?
comonly how meny mappings r there in Banking projects?
How do you migrate data from one environment to another?
Can we create out put ports in source qualifier t/r?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
In dimension and fact table? which one holds big data?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
What is the difference between a shortcut of an object and copy of an object? Compare them.