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

What are the different common services in datastage?

1332

---

What are the partitioning techniques available in link partitioner?

2320

---

Is it possible to query a hash file?

2054

---

How a server job can be converted to a parallel job?

1137

---

How do you import and export data into datastage?

1291

---

What is the difference between datastage and datastage tx?

1112

---

How many types of hash files are there?

1233

---

What is the process of killing a job in datastage?

1067

---

Name the third party tools that can be used in datastage?

1134

---

Can you explain kafka connector?

1370

---

how can we create rank using datastage?what is the meaning of rank?

8845

---

How to read the length of word in unix?

1433

---

Which algorithm you used for your hashfile?

1226

---

What is difference between server jobs & parallel jobs?

1083

---

What is oci?

1349

---