When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
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
What are data-driven sessions?
Which files are created during the session rums by informatics server?
Can informatica load heterogeneous targets from heterogeneous sources?
What is a joiner transformation?
How can you generate reports in informatica?
Enlist the differences between database and data warehouse.
What differs when we choose the sorted input for aggregator transformation?
In warehouses how many schemas are there?
What if the source is a flat-file?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the difference between source qualifier transformations source filter to filter transformation?
Slowly changing dimensions, types and where will you use them
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can you generate sequence numbers without using the sequence generator transformation?
Quickly characterize reusable change?