what is the main advantage of unconnected lookup

Answer Posted / praveen sh

If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is native users?

725


what are the deliverables?in your project?

1665


Name at least 5 different types of transformations used in mapping design and state the use of each.?

674


Where can we find the throughput option in informatica?

604


What is the Process to creating lookup transformation in informatica

589






Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2430


To import the flat file definition into the designer where should the flat file be placed?

681


What is workflow? What are the components of the workflow manager?

646


How can we use mapping variables in informatica?

602


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

1594


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1635


How do you change a non-reusable transformation to reusable transformation?

600


What is workflow monitor?

605


What is joiner change?

686


How to create or import flat file definition in to the warehouse designer?

620