in which situations we go for pesistent cache in lookup and
which situations go for shared lookup cache?
Answers were Sorted based on User's Feedback
Answer / naga
If the lookup does not change between sessions, you can
configure the transformation to use a persistent lookup
cache. When you run the session, the Integration Service
rebuilds the persistent cache if any cache file is missing
or invalid.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sbvp
1.persistent is session level. it increase the perfomance.
it is useful for mutliple session runs.
2.if we want to lookup on mutli t/r's we go for shared
lookup
thanks
sbvp
Is This Answer Correct ? | 0 Yes | 0 No |
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What do you mean by channel change?
In update strategy target table or flat file which gives more performance ? why?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
How to recover sessions in concurrent batches?
What is a repository? And how to add it in an informatica client?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
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
What are set operators in Oracle
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Performance tuning in UNIX for informatica mappings?