Answer / sabyasachi

Some of theOracle Analytical functions are like DENSE_RANK
(), RANK(),CUM_DIST(),CUM_AVG() etc. One get the
fuctionalities of some of these functions such as rank by
using a rank transformation.

For other types of functions one can resort to custom
transformation.

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

why we use datawarehouse

0 Answers   HCL,

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---