Interested to Buy Any Domain ? << Click Here >> for more details...
When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
- 2 Answers
- 9407 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / harish konda
Dynamic cache is used to update/insert the records into the
cache during the session run. From there we can
update/target table with the NewLookupRow values returned by
lookup.
If you want to use the same lookup cache in other mappings
also then we will go for Persistent Cache.
The difference is for eg, in the first mapping when we use
dynamic cache, when the session ends, the cache gets deleted
automatically. So to use this cache in other mappings also
check give one option "Persistent Cache".
So when we use this option, the cache in the memory gets
Saved even after session ends. From there we can use that in
other mappings.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
Explain about cumulative Sum or moving sum?
what is degenerated dimension?
How do you load alternate records into different tables through mapping flow?
How do you set a varible in incremental aggregation
What are the tasks that can be performed using sq?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is flashback table ? Advance thanks
Write the prerequisite tasks to achieve the session partition?
Parameter and variable differences
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is parallel processing in informatica?
What is the Rank index port in Rank transformation?
