Interested to Buy Any Domain ? << Click Here >> for more details...
what is shared Cache. when we will use shared Cache?
- 4 Answers
- 21367 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 |
What is log file,and where is it located,why u r using the log file
whatis the default data driven operation in informatica
in performance wise union is past,union all is past
Explain lookup transformation source types in informatica
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
How can you run a session without using server manager?
What are the reusable transforamtions?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
Explain direct and indirect flat file loading (source file type) - informatica
what are the deliverables?in your project?
Teradata 
