What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?

Answer Posted / srinu

conn LKP Trans CACHE Reusable with Persistent caache
option.
Conn lkp supports Default value.

---------

UNCONN LKP Trans CACHE not reusable.
UNCONN LKP Trans Not support Default value.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load only null records into target? Explain through mapping flow.

1767


What's the layout of parameter file (what does a parameter file contain?)?

2170


How to load the data from a flat file into the target where the source flat file name changes daily?

795


explain abt ur project architecture?

1917


How to update source definition?

845


Explain what transformation and how many are there in informatica?

697


How to create a non-reusable instance of reusable transformations?

882


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6587


Explain pmcmd command usage in informatica

895


What is mapplet in informatica?

766


What is DR strategy for Informatica project?

904


What differs when we choose the sorted input for aggregator transformation?

797


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1243


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

819


How does a sorter cache works?

783