What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?
- 7 Answers
- 16010 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
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Quickly characterize reusable change?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is rank index in rank transformation?
What happens when a session fails and you click on recover?
Explain about cumulative Sum or moving sum?
Differentiate between a repository server and a powerhouse?
How does a sorter cache works?
What are the modules in Power Center
Separate from a database, an information bazaar, and an information stockroom?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
In informatica workflow manager, how many repositories can be created?
How can we store previous session logs?
