What are the Differences between connected and unconnected
lookup?
Answer Posted / mayur
Connected Lookup
- In mapping flow (Pipeline)
- One or more output (Multiple return port)
- Can Assigned Default Value
- Have to create new if more than one table to lookup in the same mapping
Unconnected Lookup
- Not in mapping flow
- Only one output (Single return port)
- Can’t assign default value
- Can use multiple time
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to start a workflow using pmcmd command?
What is joiner transformation?
How to go to the older version for a mapping?
What is the cumulative sum and moving sum?
What are the different types of transformation available in informatica.
How can you generate reports in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the various types of transformation?
How do you update the records with or without using update strategy?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to generate sequence numbers?
What is mapplet in informatica?
How are the sources and targets definitions imported in informatica designer?
Explain Dataware house architecture .how data flow from intial to end?