Answer / swetha

During the session ,the informatica server compares an inout
row with rows in the datacache. If the input row out-ranks a
stored row, the informatica server replaces the stored row
with the input row. The informatica server stores group
information in an index cache and row data in a data cache.

Answer / shashiall

Swetha answer is correct.Expanding little bit with example.
If there r 3 same salaries..Rank will eliminate the
sequences..try this...rank will come 1,2,3,3,3,6..
To confirm this go to the SQL editor and check this with
Dense rank()function.

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

What are the different threads in DTM process?

2 Answers  

---

What are session parameters ? How do you set them?

0 Answers  

---

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

Define Update Override?

1 Answers  

---

What are the joiner caches?

3 Answers   Informatica,

---

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---