Answer / datastage4you

Some Interview Questions and Scenario -

http://www.datagenx.net/p/datastage-scenario.html
http://www.datagenx.net/p/datastage-posts.html
http://datastage4you.blogspot.in/p/blog-page_15.html

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

What are the benefits of datastage?

0 Answers  

---

How to Remove Duplicate using SQL?

0 Answers   CTS,

---

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

How can we improve performance of data stage jobs?

0 Answers  

---

What are the main features of datastage?

0 Answers  

---

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  

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

---