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.

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

What are the types of caches in lookup?

0 Answers  

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,

How can you join two tables without any common column present in them?

1 Answers   TCS,

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,