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.

Answer / suresh

no

Answer / rakesh

thanks suresh, and can any one explain why(the reason)?

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.

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.

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

Repository user profiles

0 Answers  

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

What is IQD file?

1 Answers  

define galaxy repository in informatica

0 Answers  

Can u generate reports in Informatica?

0 Answers   Informatica,

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

If informatica has its scheduler why using third party scheduler?

0 Answers  

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

what is the gap analysis?

1 Answers