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 |
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
tell me about your project functionality
Can you generate sequence numbers without using the sequence generator transformation?
what is session parameters?
What is the commit type if you have a transaction control transformation in the mapping?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
Explain dynamic target flat file name generation in informatica
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
What is informatica worklet?
What are the features of complex mapping?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?