Buy Datastage Material

Full Datastage Material -- $9 Or 500 Rs

How to create group id in Sort Stage in Datastage

Group ids are created in two different ways.

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

group id's

If the data we are getting is sorted data, then we use Cluster Key change Column to

create Group Id's







No comments:

Popular Posts