1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
- 4 Answers
- 11520 Views
- Virtusa, I also Faced
- E-Mail Answers
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
How many ways are there to do 'remove duplicate records in informatica'?
Explain the etl program with few examples.
What differs when we choose the sorted input for aggregator transformation?
What is xml source qualifier transformation in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the limitations of joiner transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
What do you mean by channel change?
What is data transformation manager process?
How identifying bottlenecks in various components of informatica and resolving them?
What do you mean by filter transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
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?
Which means the first record should come as last record and last record should come as first record and load into the target file?
According to his methodology what all you need before you build a datawarehouse
