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

How do you schedule or monitoring the job?

1149

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3280

---

How do you start developing a datastage project?

1070

---

Lookup constraints

1207

---

What are routines in datastage?

1278

---

Explain Quality stage?

1103

---

what is use of SDR function?

5139

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4152

---

How do you import and export the datastage jobs?

1118

---

Differentiate between data file and descriptor file?

1001

---

How to read the length of word in unix?

1321

---

What are sequencers?

1071

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2418

---

What is the difference between datastage and informatica?

1067

---

How will you move hashed file from one location to another location?

2109

---