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.

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

What is status code in informatica?

1 Answers  

---

What will be the approach?

1 Answers  

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

What is flashback table ? Advance thanks

1 Answers   Puma,

---

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

Explain the code page compatibility?

1 Answers  

---

what is the flow?

1 Answers  

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---