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.

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

Describe the architecture of datastage?

0 Answers  

---

How did you reconcile source with target?

3 Answers   HP,

---

What is the use of Row generator stage?

2 Answers  

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

What is RCP

5 Answers   CGI, CTS,

---

What is a range lookup?

2 Answers   IBM,

---

what is advantages of snowflake when it is used?

3 Answers   IBM,

---