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
What does role playing dimension mean?
What is a dimensional model?
What is a standalone command task?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to load data in informatica ?
What are mapplets?
How do you use reject loader.
What is the difference between source qualifier transformations source filter to filter transformation?
What are the different lookup cache(s)?
What is the sql query overwrite in source qualifier in informatica
What are the different options available for update strategy?
What is persistent lookup cache?
As union transformation gives UNION ALL output, how you will get the UNION output?
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
Why filter transformation is an active one?