Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 25483 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasuna
1) A connected Lookup transformation receives input values
directly from another transformation in the pipeline.
An unconnected Lookup transformation receives input values
from the result of a :LKP expression in another
transformation. You can call the Lookup transformation more
than once in a mapping.
2)IN connected The Integration Service passes return values
from the query to the next transformation.
In Unconnected The Integration Service returns one value
into the return port of the Lookup transformation.
3)Connected uses Dynamic or Static Cache,whereas
Unconnected use a static cache
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are ETL Tools?
Explain direct and indirect flat file loading (source file type) - informatica
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
wat are deployement groups in informatica, how it will be used for developers
How you know when to use a static cache and dynamic cache in lookup transformation?
What is sequence generator transformation in informatica?
have u done any performance tuning? how u ll do?
Explain sessions. Explain how batches are used to combine executions?
How many ways are there to create ports?
How would you join a node to the already existing domain?
What is the surrogate key?
How to generate sequence numbers without using the sequence generator transformation?
Enlist the advantages of informatica.
