Answer / deepanshu

supposing single column is there having values
278
951
736

sol'n :
Use transformer string function with @inrownum variable.

inputcolumn[@inrownum,1]
will give you desired o/p

Answer / 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 the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

---

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

0 Answers   CTS,

---

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers  

---

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

0 Answers   Virtusa,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

What is the default padding character?

3 Answers   IBM,

---

how do u capture duplicates through sort & transformer

4 Answers  

---

What is a folder? Difference types of stages?

0 Answers  

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---