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.

How many types of views are there in a datastage director?

832

---

How to perform incremental load in datastage?

664

---

What is the difference between account and directory options ?

620

---

Differentiate between data file and descriptor file?

615

---

How do you import and export data into datastage?

699

---

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1624

---

What are stage variables and constants?

700

---

What is "fatal error/rdbms code 3996" error?

663

---

What is the flow of loading data into fact & dimensional tables?

589

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

1929

---

What are the benefits of datastage?

721

---

client know skid info?

1631

---

What is a ds designer?

638

---

What is the roundrobin collector?

635

---

What is the different type of jobs in datastage?

568

---