Answer / 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

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,

---

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc Ple help any one?

4 Answers   SLK Software,

---

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

---

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,

---

How do u call shellscript/Batch file from DS?

4 Answers   HP,

---

what is snow flack schema?

2 Answers  

---

How to reverse the string using SQL?

0 Answers   CTS,

---

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

---

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,

---