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.

Explain what are the different versions of informatica?

0 Answers  

---

How can a transformation be made reusable?

0 Answers   Informatica,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

How to generate sequence numbers?

0 Answers  

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,

---

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

How to Create a folder using pmrep command?

0 Answers  

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

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

8 Answers   DELL,

---

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

---