CONCATENATE DATA USING TRANSFORMER STAGE
e_id,e_name,e_job,e_Sal
1,sam,clerck,2000
2,tim,salesman,2100
3,ram,clerck,1800
4,jam,salesman,2000
5,emy,clerck,2500
Read and Load the data in sequential file
In Transformer stage Create one column as Total_one
In derviation you can write expression as below
click ok
Give File name in the target file
Compile and Run the Job
That's itCONCATENATE DATA USING TRANSFORMER STAGE
3 comments:
expression is not showing
Expression is not there
You can use Concatenate operator : so the complete derivation should look something like this DSLink44.id: " " : DSLink44.job: " " : DSLink44.name : " ": DSLink44.sal
Post a Comment