Can we use unconnected lookup as dynamic lookup?
Answers were Sorted based on User's Feedback
Answer / dev
Unconnected lookup will return one port only. But dynamic
lookup will return more than one port and it update and
insert the targt while session runs.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / ajay
In addition to above. When we enabled the dynamic cache the
return port is disabled. And in un-connected lookup lookup
must return a value.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amit
With unconnected lookup - we can call unlkp zero times or n-times into our mapping.
With dynamic cache - the Integration Service insert or update rows into the cache or leaves it unchanged depending on lookup condition.
Suppose if the dynamic cache option is available in unconnected lookup, the Integration Service couldn't determine which is correct call (unconnected lookup can call n-times) for update/insert rows into lookup cache. Hence, the Informatica does not support Dynamic Lookup Cache with Unconnected Lookup by default to avoid this ambiguity.
Is This Answer Correct ? | 0 Yes | 0 No |
what is lookup ?
What are ETL Tools?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
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?
how did u understand business requirement?
what are the perameter and variable?
what is runtime variable?
How u use pdf file in informatica source?
What is a transaction control transformation?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
what is lookupoverriding?
Can we use the mapping parameters or variables created in one mapping into another mapping?