what is shared Cache. when we will use shared Cache?
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 |
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
how you will maintain version?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
What is power center repository?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
what is constraint based load order
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
Differnce between filter and router?
If we set dd_insert in mapping and Delete in session properties what will happen.?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Tell me about MD5 functions in informatica
What is sq transformation?