Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use unconnected lookup as dynamic lookup?
- 5 Answers
- 17476 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 |
What is meta data and system catalog?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
What is a grid in Informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the different transaction levels available in transaction control transformation?
How to load query faster,so that It will take less time to load?
 Code page compatibly –Where all changes are made to handle the scenario.
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
Define joiner transformation?
What is lookup transformation?
How can we integrate different flat file data in a single mapping and with in a single execution
Teradata 
