Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 25928 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasuna
1) A connected Lookup transformation receives input values
directly from another transformation in the pipeline.
An unconnected Lookup transformation receives input values
from the result of a :LKP expression in another
transformation. You can call the Lookup transformation more
than once in a mapping.
2)IN connected The Integration Service passes return values
from the query to the next transformation.
In Unconnected The Integration Service returns one value
into the return port of the Lookup transformation.
3)Connected uses Dynamic or Static Cache,whereas
Unconnected use a static cache
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
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 incremental aggregation in informatica
Where is metadata stored?
Slowly changing dimensions, types and where will you use them
Which is the t/r that builts only single cache memory?
Can we get 1st record through Informatica(without sequence number).
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How many input parameters can exist in an unconnected lookup?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Implementation methodology
Which transformation is needed while using the Cobol sources as source definitions?
What you know about transaction control transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is target designer and target load order?
