DSXchange

Scenario.

i have 3 fields coming in as an input say( ID, Name, Age). And i want to introduce one field call "Indicator".

Now if i have duplicate combinationcoming in the output should look like

ID Name Age Indicator
1 Surjit 25 1
1 Surjit 25 2
1 Surjit 25 3
2 XYZ 26 1
2 XYZ 26 2
3 rty 34 1
3 rty 34 2

the output should be such that there should be a generated sequence number for each unique grouping of (ID,Name and Age)

Is it possible in dataStage

It is possible.
Very similar situations have been dealt with before. Do a search, if you don't find any, get back.

What are the inputs?
How the field Indicator is decided upon? ie., how the cound 1,2,3 or 1,2 is decided?
Answer for this vary with respect to your reply.

Use sorted (by ID) input and stage variables to detect change and increment/reset sequence number.

Hereis a similar post.