Can we use unconnected lookup as dynamic lookup?
Answer Posted / 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 |
Post New Answer View All Answers
How to delete duplicate row using informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to start a workflow using pmcmd command?
Briefly explain the aggregator transformation?
What is a node in Informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can you use flat files in Mapplets.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How many ways a relational source definition can be updated and what are they?
server hot-ws270 is connect to Repository B. What does it mean?
How to update a particular record in target with out running whole workflow?
Explain constraint based loading in informatica