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.

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

explain about session partitions ?

1 Answers  

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

define galaxy repository in informatica

0 Answers  

---