Answer / Sarfaraj Khan

Lookup transformations in Informatica use different caching strategies to improve performance. There are three main types of caches in a Lookup transformation:
1. Cache by RowID: This cache stores the input rows using their RowIDs, which speeds up subsequent lookups as the RowID can be used directly to find the corresponding value in the lookup table.
2. Cache by Key: In this cache type, the input keys are stored along with their corresponding values. It is useful for smaller lookup tables where the key-value pairs can fit into memory.
3. Dynamic Cache: The Dynamic Cache is a hybrid approach that combines both Cache by RowID and Cache by Key strategies. Initially, it uses Cache by RowID; when the cache size exceeds the configured limit, it switches to Cache by Key for the remaining entries.

In which circumstances that informatica server creates Reject files?

2 Answers  

---

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

What is power play plug in?

2 Answers  

---

Can we run session without using workflows?

5 Answers   TCS,

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

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,

---

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

---

What are the tuning techniques you applied during your last project

1 Answers  

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---