Monday, September 1, 2014

SORT STAGE AND TRANSFORMER STAGE WITH SAMPLE DATA EXAMPLE


SORT STAGE AND TRANSFORMER STAGE WITH SAMPLE DATA EXAMPLE

If we have some customers information as below.

cust_info
c_id,c_name,c_plan
11,smith,25
22,james,30
33,kelvin,30
22,james,35
11,smith,30
44,wagon,30
55,ian,25
22,james,40



We can see the customers information and there mobile plans ( for example)

If we like to find lowest plan taken by all customers

Take Job Design as


Seq.File--------Sort------Tx-----------------D.s



Read and Load the data in Sequential file

In Sort Stage select Key Change =True to generate group id

In Transformer Stage write Key Change=1 in Constraint

Write File name for Target D.S File

Compile and Runt the Job

You Get the Output as required

Lowest plans of the customers.


1 comment:

Rinki Gupta said...

In sort stage which colm need to choose as key and key change col will generate for which colm value.