Replicating input rows based on condition

[Gokul]

Hi ,

I am designing a job which requires , that for each record of source it will replicate the source record N times depending on some condition(ex.N=Number of matching Records found in Hash).

Desgin i used is

Src-----|
|----------------Transform---------->Target
Hash---|

I tried with @outrownum .but could not go further.
I have achieved the solutiin through Unix scripts.
Can this be done in Data Stage.

[Sainath.Srinivasan]

If the replication count is the number of matching records in another (hash) file, you can write both in a seq file and use the merge stage to join. There is another thread with similar requirements. Search the forum for more info.