What are the Differences between connected and unconnected
lookup?
Answer Posted / varma koilada
Connected lookup participates in the mapping ( dataflow )
just like any other transformation. Unconnected lookup is
used when a lookup function is used instead in an expression
transformation in the mapping in which case the lookup does
not appear in the main flow ( dataflow ) of the mapping.
Connected lookup can return more than one value ( output
port ) whereas Unconnected gives only one output port.
Unconnected lookups are reusable.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What do mean by local and global repository?
What are the main issues while working with flat files as source and as targets ?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is primary and backup node?
Is it possible to use a client with different version than that of its Informatica server?
What does “tail –f” command do and what is its use as an Informatica admin.
How to create the source and target database connections in server manager?
What is a repository? And how to add it in an informatica client?
What is a router transformation?
wat are deployement groups in informatica, how it will be used for developers
What is informatica worklet?
What is rank index in rank transformation?
What is a snowflake schema?
Can we get 1st record through Informatica(without sequence number).