Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use unconnected lookup as dynamic lookup?
- 5 Answers
- 17434 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 will the document be delivered to me?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
What is intricate mapping?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What is a predefined event?
What is the need for an etl tool?
What are parallel querys and query hints?
Explian the Process of deployment groups in informatica
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
why normalizer transformation can not used in mapplet? plzzzz answer
Explain in detail about scd type 1 through mapping.
Teradata 
