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
Which are the different editions of informatica powercenter that are available?
What are the prerequisite tasks to achieve the session partition?
What is the status code in stored procedure transformation?
What is a joiner transformation?
how to load dimension table and fact table. plz tell me the steps.
Does an informatica transformation support only aggregate expressions?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain load alternative records / rows into multiple targets - informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Clarify the aggregator change?
What is mapping debugger?
What is complex mapping?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
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 ?