Answer / ramu

persistent cache is used when u r mapping contains multiple dimensions table, which is used in several times. if you use persistence cache all the index files and data files are stored in memory. when the integration serviece second time calls the same lookup table it wioll fetch the data from the memory cache files instead of re-creating the index and data cache files. we can use the same cache by using one name prefix of the lookup properties.
to use use persistence cache we can divide them in to two types.
1) names persistence cache
2) un named persistence cache.

1) named persistence cache: we can use the same persistence cache between several mappings.
2)un named persistence cache we can use the same cache with in the mapping only.

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

what is a time dimension? give an example?

2 Answers   IBM,

---

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  

---

Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  

---

where to select code page option?

2 Answers   TCS,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

Where are the source flat files kept before running the session?

0 Answers   Informatica,

---