Column Generator is a development stage/ generating stage that is used to generate column
with sample data based on user defined data type .
Take Job Design as
Seq.File--------------Col.Gen------------------Ds
Take source data as a
xyzbank
e_id,e_name,e_loc
555,flower,perth
666,paul,goldencopy
777,james,aucland
888,cheffler,kiwi
In order to generate column ( for ex: unique_id)
First read and load the data in seq.file
Go to Column Generator stage -- Properties -- Select column method as explicit
In column to generate = give column name ( For ex: unique_id)
In Output drag and drop
Go to column write column name and you can change data type for unique_id in sql type and
can give length with suitable name
Then compile and Run
No comments:
Post a Comment