Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use unconnected lookup as dynamic lookup?
- 5 Answers
- 17685 Views
- ITC Infotech, TCS, Wipro, I also Faced
- E-Mail Answers
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 |
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
design of staging area?
have you developed documents in your project? and what documents we develop in realtime?
Why filter transformation is an active one?
what is the use of Java Transformation in Informatica 8.x?
What is informatica metadata and where is it stored?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
what is Partitioning ? where we can use Partition?
To import the flat file definition into the designer where should the flat file be placed?
What are partitions in informatica and which one is used for better performance?
why do we go for update strategy tr in SCD rather using the session properties?
What are the advantages of informatica?
Teradata 
