Wednesday, April 13, 2011
Field Function in Transformer Stage with example
Posted by tom smith at 11:12 PM Labels: Examples, Functions, Transformer-Stage-Example, TransformerStageSome times we get the data as below
Take Job Design as
Seq.File ------- Tx ------ Ds
Read and load the data in Seq.file
Select first line is column name
And in Transformer stage Create three columns to get the data
You can take columns names as c_id,c_name,c_sal with respective data types.
Write the expression in Derivations to the columns as below
Field (dslink3.customers,',',1) for c_id
Field (dslink3.customers,',',2) for c_name
Field (dslink3.customers,',',3) for c_sal
That's it you will get the data in 3 different columns in the output as required.
After compile and Run the Job.
If you know Better Answer for Above Question Comment below to Answer.
Change Capture Stage is used to capture the changes between two sources based on the change code. Change Code is the Code generated w...
Some times we get the data as below Customers 1,tommy,2000 2,sam,2300 3,margaret,2000 4,pinky,1900 5,sheela,2000 Take Job Design...