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
group and create sequence..is it possible in DataStage
Moderators: chulett, rschirm, roy
group and create sequence..is it possible in DataStage
Last edited by Smeitei on Wed Feb 14, 2007 8:52 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: