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

What is the use of source qualifier?

660


What is a shortcut and copy in Informatica and how two are different with each other?

669


how to load rows into fact table in data warehouse

634


what are the deliverables?in your project?

1645


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

543






In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1528


How can a transformation be made reusable?

657


what is diff b/t sorter t/r and agg have the option sorter property...

1731


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1610


How to improve the performance of a session using sorter transformation?

680


In which transformation you cannot drag ports into it?

774


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

609


What is Data Caches size?

650


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1629


difference between informatica 8.1.1 and 8.6

3235