DSXchange

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

You typically 'get the data in sequence' by sorting, would that not work for you here?

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.

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. ...

Thanks for your help, below one is the process,

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

Use ORDER BY in the extraction and use a Sort funnel to preserve the sorted order.

If the target is a database stage, there's generally no reason to sort the output data. Why do you think you need to do this? Or do you need to sort it before transforming it?