Hi Friends,
Can any one help to me, how to get the data in sequence, below example will show the structure and give the idea.
EX:
1 000021158710
1 000021158720
1 000021158730
2 000021191310
2 000021191320
2 000021191330
3 000021191410
3 000021191420
3 000021191430
Get data in sequence
Moderators: chulett, rschirm, roy
Thanks for your help, below one is the process,kumar_s wrote:Whats your source and tareget?
As mentioned, Use sort stage or order by clause with both the the fields.
Not sure, if your question is about partiton. ...
1. Extract the data from ODBC
2.Use the Transformer for business logic (concatenate two names) other than concatenate, not using any logic in transformer. And give the 3 output links for funnel, in this each link. have to pass the data.
link 1 --> name10 JA10
link 2 --> name20 JA20
link 3 --> name30 JA30
3. Put the result in oracle stage
Note: extracted rows 20 and out put rows 60
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: