Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?
- 7 Answers
- 18771 Views
- I also Faced
- E-Mail Answers
Answer Posted / pradeep
1) The connected lookup t/r connected other transformations in the pipe line and it recives input data directly from pipe line.
where as unconnected lookpup t/r not connected other t/r in the pipe line and it recive input data from the result of :LKP Expression in an other t/r,that support expressions.
2)Connected lookup support user defined functions
Unconnectd doesn't support user defined functions.
3) It returns multiple output values to other t/r
Unconnected returns single output value to other t/r.
4)Connected lookup support static and dynamic cache
Unconnected supports only static cache.
5)Connected lookup cache includes output ports in the lookup condition
Where as in unconnected lookup cache include lookup ports of lookup condition.
6)Connected lookup gives multiple output ports to other t/r.
Unconnected lookup gives single output port to other t/r.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain sessions. Explain how batches are used to combine executions?
What will be the approach?
How can we delete duplicate rows from flat files?
How can we use mapping variables in informatica?
How to handle decimal places while importing a flatfile into informatica?
Enterprise data warehouse your projects phase by phase explain?
How to elaborate powercenter integration service?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Briefly explain the aggregator transformation?
What is the reusable transformation?
What is confirmed fact in dataware housing?
without table how to come first record only in oracle?
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?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
