In which situation we will use persistant cache and shared
cache in real time. plzsss answer with example
Answer / nitish kumar
Persistant cache we use when our data or lookup values are not changing frequently so as we know Persistant cache will be saved in cache folder so it can be reused in next session run. Because of this reusability this will basically reduce the run time of workflow.
Also since in persistant cache we have a copy of cache file we can share the same cache to other session if it required.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the need of building a data warehouse?
What are batches?
What is fact table? Explain the different kinds of facts.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
Can i create a lookup table without cache.
What is target load order?
how may sources can be used in a mapping at a time?(limit)
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
how to return multiple columes through through un-connect lookup?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Can informatica load heterogeneous targets from heterogeneous sources?