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.

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

What if the source is a flat-file?

0 Answers  

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---

Have you worked with/created Parameter file

0 Answers  

---

Informatica settings are available in which file?

0 Answers   Informatica,

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

What are the data movement modes in informatica?

0 Answers   Informatica,

---

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

what is a time dimension? give an example?

2 Answers   IBM,

---

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

---