DSXchange

I have a table consists of 2 columns and required o/p is input should be duplicated n times.
n may be 2,3,5


Ex-if n is 2 and no of records in i/p is 3.required o/p is 6 rows(3*2)

I can acheive using looping,copy+funnel stage but want to know is there any single stage in datastage which can get the required output

Transformer with looping would be your 'single stage'.

What Craig said is your best choice. Make n a job parameter, and compare it to @ITERATION as your loop continuation condition.

thanks for quick response and apart from transformer with looping is it possible to achieve the same functionality with single stage?

No.

Well... unless you count writing a BuildOp or some other external solution as a 'single stage' solution.