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.

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

can we use self join in informaitca?

3 Answers   IBM,

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---

What are the different options available for update strategy?

0 Answers  

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

---

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

What is a surrogate key?

0 Answers  

---

What are junk dimensions?

0 Answers  

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---