Answer Posted / raj

The only solution I can get readily is using stage variables in a transformer. In order to achieve this I need to define 3 stage variables to map them to input columns. Another 3 stage variables to store the previous value. Another 3 variables to compare the values. A total of 9 stage variables are needed.

To reduce the number of stage variables, lets us checksum stage

A checksum stage generates a unique value with the given columns as input.

We supply these three columns as input and generate unique values for each combination and then use that value for comparison in the transformer

Transformer:
Stage Variable:

Checksum -> Sv1
Sv2 -> Sv1
if Sv1=Sv2 then Sv3+1 else 1 -> Sv3

Sv3 -> SEQNO

We get the desired output

Describe routines in datastage? Enlist various types of routines.

954

---

Name the command line functions to import and export the DS jobs?

1089

---

What is the difference between datastage and datastage tx?

1005

---

What is orabulk stage?

991

---

What are some prerequisites for datastage?

1037

---

Explain how a source file is populated?

1308

---

What is difference between symmetric multiprocessing and massive parallel processing?

1078

---

What is the project in datastage?

1045

---

What is usage analysis in datastage?

1261

---

whom do you report?

1879

---

Which algorithm you used for your hashfile?

1120

---

Which warehouse using in your datawarehouse

2113

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2756

---

How you can fix the truncated data error in datastage?

1673

---

What is the method of removing duplicates, without the remove duplicate stage?

954

---