We can create group id's by using
a) Key Change Column
b) Cluster Key change Column
Both of the options used to create group id's .
When we select any option and keep true. It will create the Group id's group wise.
Data will be divided into the groups based on the key column and it will give (1) for
the first row of every group and (0) for rest of the rows in all groups.
Key change column and Cluster Key change column used based on the data we are getting
from the source.
If the data we are getting is not sorted , then we use key change column to create
If the data we are getting is sorted data, then we use Cluster Key change Column to
create Group Id's