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
- 18998 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
Please let me know how to make Data masking in informatica..
What is meant by target load plan?
What does update strategy mean, and what are the different option of it?
expain about the tune parameters?
What is event and what are the tasks related to it?
what is the hint? how to use it to reduce the query processing in program?
What is the meaning of up gradation of repository?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain sql transformation in script mode examples in informatica
Explain lookup transformation in informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain your project of banking domian.
Is it possible to revert a global repository to local one and why?
What is the commit type if you have a transaction control transformation in the mapping?
Explain about cumulative Sum or moving sum?
