what is shared Cache. when we will use shared Cache?
- 4 Answers
- 21570 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rao
shared cache is a one of the lookup caches of a lookup
transformation.
if we choose this option Informatica server creates the
cache memory for multiple lookup transformations in the mapping.
when first lookup transformation function completed then
memory is released and use that memory used by the other
look up transformation.
| Is This Answer Correct ? | 12 Yes | 4 No |
Answer / matt
We are talking about shared vs split cache.
Split cache is when data and instructions are located in different locations in cache.
Shared cache is when data and instructions are located in the same area of cache.
Is split cache effective? It depends on the program, and how heavily it relies on the data vs the instructions...
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / srinu
shared is used for multiful t/r.if unnamed shared cache
used b/w t/r in same mapping.
named cache used b/w t/r in same and different mapping.
srinu
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pushparao
shared cache is used to store the all scheduled information
with in a session.
| Is This Answer Correct ? | 0 Yes | 10 No |
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
1 Answers Cap Gemini, Cognizant,
What is the Difference between sorter and aggregator?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Why update strategy and union transformations are active? Explain with examples.
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
can we use self join in informaitca?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
How to recover sessions in concurrent batches?
Teradata 
