Pages

▼

Monday, September 1, 2014

CONCATENATE DATA USING TRANSFORMER STAGE


CONCATENATE DATA USING TRANSFORMER STAGE
If we have a Table as below

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
at

3 comments:

  1. UMAOctober 6, 2017 at 11:21 AM

    expression is not showing

    ReplyDelete
  2. RajeshAugust 23, 2019 at 5:24 AM

    Expression is not there

    ReplyDelete
  3. UnknownJuly 10, 2020 at 11:17 PM

    You can use Concatenate operator : so the complete derivation should look something like this DSLink44.id: " " : DSLink44.job: " " : DSLink44.name : " ": DSLink44.sal

    ReplyDelete