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 types of jobs we have in datastage?

682

---

Why do you need stage variables?

678

---

Terminate Activity

848

---

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

1940

---

How can we improve the performance in datastage?

663

---

---

What is the project in datastage?

679

---

What is the roundrobin collector?

649

---

What steps should be taken to improve Datastage jobs?

652

---

Can you define merge?

674

---

What are some different alternative commands associated with "dsjob"?

671

---

Describe the main features of datastage?

666

---

What is the use of hoursfromtime() function in transformer stage in datastage?

591

---

Differentiate between Join, Merge and Lookup stage?

658

---

What are the functionalities of link partitioner and link collector?

608

---

Demonstrate experience in maintaining quality process standards?

1957

---