When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
- 3 Answers
- 11648 Views
- I also Faced
- E-Mail Answers
Answer Posted / vinod saini
Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
What are the main features of Oracle 8i with context to datawarehouse?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the different types of repositories created using informatica?
What are the types of caches in lookup?
Explain joiner transformation in informatica
list out all the transformations which use cache?
Explain the different dimensions.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to generate sequence numbers without using the sequence generator transformation?
Implementation methodology
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Mention a few design and development best practices for informatica?
How do you load first and last records into target table?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
