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
- 18383 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
Define update strategy?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How you can differentiate between connected lookup and unconnected lookup?
can you please explain me pre session and post session options?
How you prepared reports for OLAP?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What you know about transaction control transformation?
What is a passive transformation?
What is a grid in Informatica?
What is a repository manager?
How to load data in informatica ?
what is the -ve test case in your project.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain the types of lookup transformation?
