rank function in bods

dataservices job design
1

Hi guys

I am need rank functionality in the dataflow… I tried Rank() OVER (ORDER BY ID) in sql server which works fine… data look like:-

ID Rank_expected
101 1
101 1
101 1
102 4
103 5
103 5

I tried order by ID in 1 query transform and used gen_row_num_by_group(ID) in next query transform but the result is not coming as per expected

ID Rank_DS_Generate
101 1
101 2
101 3
102 1
103 1
103 2

leo_dec11 (BOB member since 2009-06-18)

2

When using functions that require data to appear in an ordered state the same way every time, be sure you set the DOP to 1 for the Dataflow. If you don’t do that then the Dataflow can split the data after it is sorted and in subsequent transforms the data will be processed out of order.

Try doing that first. If that doesn’t work then post back here and let’s see what else needs to be done.

eganjp :us: (BOB member since 2007-09-12)