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.

How will you combine 3 different sources with a single source?

3 Answers  

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

---

what is a time dimension? give an example?

2 Answers   IBM,

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

---

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

---

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

---