Answer Posted / bhavani

we can acheive this using transformer stage:
1. Check the record count using AGGREGTOR stage and have a column count
2. In the transformer initiate a loop with condition @ITERATION <=count. and loopvar = @iteration
3.if @INROWNUM = loopvar then right(left(@iteration),1) --> output value

Now the result will be 2
5
6

Let me know if this is correct.

What are the processing stages?

1105

---

Give an idea of system variables.

1038

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3800

---

What is data partitioning?

1211

---

What is datastage?

1090

---

What are some prerequisites for datastage?

1104

---

What is active and passive stage?

1414

---

What are the various kinds of containers available in datastage?

1048

---

project Steps,hits, Project level HArd things,Solved methods?

2137

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1748

---

How many types of stage?

1181

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1041

---

What is a quality stage in datastage tool?

1081

---

How do you generate sequence number in datastage?

1101

---

What are the different plug-ins stages used in your projects?

1078

---