what is the advantage of persistent cache? when it should be
used?
Answer Posted / san
when the table you are using for lookup is static table(
i.e. data is not changing ) and it is the huge table.
Hence reduce the session time by using the persistent cache
file/s.
Regards,
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give the benefits of data integration suite?
how do u extract data from different data sources explain with an example?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What is partitioning? Explain about round-robin, hash partitioning.
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Explain etl?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
Explain different types of partitioning?
Define slowly changing dimensions (SCD)?
how to connect to a flatfile through ftp in informatica
What is tracing level and what are the types?