Answer / priyaraj

The dynamic cache represents the data in the target.The
integration service uses the data in the associated port to
insert or update rows in the lookup cache.

Answer / rajan raorane

1) It is used to insert the data in Cache and Target
2)Informatica dynamically inserts the Data in target
3) Data is inserted only when the condition is false i.e It
means no data is available in target and cache table

Answer / harish konda

The Dynamic Lookup Cache is used to update/insert the data
into the cache.

When the session starts, if dynamic cache is used, it
fetches all the target data into its cache. And during the
session IS scans the whole dynamic cache acc. to the lookup
condition we give. It updates/inserts the cache accordingly
if the row exists/new row respectively.

When dynamic cache is selected one column named
"NewLooupRow" gets added into the lookup t/f. When a row
coming from source is new then returns 1 that is insert,
when a row coming as update then its returns 2 that is
update, and when a row coming with no changes as it is in
target before then 0 is returned.

So we can use these NewLooupRow values in other t/f's
accordingly and give conditions to update/insert/reject.

So indirectly target table gets updated/inserted/deleted
according to these values of NewLooupRow only.

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

what is difference between mapping and mapplet ?

2 Answers   TCS,

---

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,

---

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

---

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

In Which scenario did u used Incremental loading?

2 Answers  

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

---

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---