Answer / kumar

Hi,
How you can Update the values by using merge stage?. It is
for joining and merging purpose only

Answer / sadanand

Merge stage is used for horizontal combining of data from
different tables having common columns.
We cannot update the values using Merge stage.
Correct me if I am wrong.

Answer / kiran

you can update values.

But Quetion is not properly.

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

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,

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---

What are some prerequisites for datastage?

0 Answers  

---

what r the sources u need to create the datastage?

1 Answers  

---

how do you pass parameters in a script?

1 Answers   L&T,

---