Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

---

What is size of a transaction and an array means in a datastage?

0 Answers  

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

---

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

---

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

---

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  

---

WHAT are unix quentios in datastage

2 Answers   TCS,

---