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 is data partitioning?

1185

---

How do you run datastage job from the command line?

1077

---

Define ds designer?

1256

---

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?

1025

---

Why do you need stage variables?

1172

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3242

---

How many areas for files does datastage have?

1144

---

What is the differentiate between data file and descriptor file?

1345

---

What is ibm datastage?

958

---

describe the Steps to confiure a Qlogic switch

2374

---

Define APT_CONFIG in Datastage?

1062

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2849

---

Define repository tables in datastage?

1142

---

Lookup constraints

1238

---

What is ds designer?

1085

---