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

How many ways are there to do 'remove duplicate records in informatica'?

670


Explain the etl program with few examples.

638


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

667


What is xml source qualifier transformation in informatica?

825


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2219






What are the limitations of joiner transformation?

746


Explain pushdown optimization $pushdownconfig parameter - informatica

810


What do you mean by channel change?

638


What is data transformation manager process?

712


How identifying bottlenecks in various components of informatica and resolving them?

685


What do you mean by filter transformation?

644


What is the difference between writing a joiner query in ANSI style and THETA style?

2010


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1628


Which means the first record should come as last record and last record should come as first record and load into the target file?

690


According to his methodology what all you need before you build a datawarehouse

1288