1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach

Answer Posted / sreenu

Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.

Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does role playing dimension mean?

627


What is a dimensional model?

583


What is a standalone command task?

656


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1464


How to load data in informatica ?

574






What are mapplets?

820


How do you use reject loader.

2071


What is the difference between source qualifier transformations source filter to filter transformation?

580


What are the different lookup cache(s)?

619


What is the sql query overwrite in source qualifier in informatica

617


What are the different options available for update strategy?

579


What is persistent lookup cache?

603


As union transformation gives UNION ALL output, how you will get the UNION output?

643


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1651


Why filter transformation is an active one?

565