What is difference between a connected look up and
unconnected look up?
Answer Posted / suresh
1.conneted T/r takes multiple inputs and gives multiple
outputs
where as unconnected t/r takes multiple inputs but gives
single output
2. in connected lookup input, output, lookup ports are
available
where as in unconnected look up having input,output,lookup
as well as return port
3. connected t/r used dynamic and static cache
where as unconnected t/r uses only dynamic cache
| Is This Answer Correct ? | 19 Yes | 13 No |
Post New Answer View All Answers
What are the various types of transformation?
Where do we use mapping variables in informatica?
How might you approve all mappings in the archive all the while?
what are the deliverables?in your project?
What is the function of union transformation?
Enterprise data warehouse your projects phase by phase explain?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Please let me know how to make encryption and decryption with example?
design of staging area?
How to update source definition?
Mention a few design and development best practices for informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the mapping parameters and mapping variables?
have u done any performance tuning? how u ll do?