how to concatenate or append current value with existing value in Datastage

Question

I need achive below requirement i.e

Input -- at very first time

Order   value
1111    aaa
 222    bbb
 333    ccc

in the target (Insert) I will have

Order   value 
Order   value
1111    aaa
 222    bbb
 333    ccc

----------Input -- at second time

Order   value
1111    Aaa1
 222    Bbb2
 333    ccc

Out put must be

Order   value
1111    aaa Aaa1
 222    bbb Bbb2

So on

I need to keep appending change values for the corresponding key column .. 111 aaa aaa1 aaa2 aaa3 ..like this

Please help

With "at second time" you mean a second execution of the job not a second set of rows in the initial job run right? — MichaelTiefenbacher, Dec 08 '17 at 12:16
yes -- at the time of update .. if any changes in the value then .. — user1793212, Dec 13 '17 at 08:13
If your target is a database a regular UPDATE statement could do this. So what is the target? — MichaelTiefenbacher, Dec 13 '17 at 17:25

score 0 · Answer 1 · answered Mar 18 '19 at 20:06

You can follow these steps:

Use a CDC stage. Here by default it keeps the following functions: 0 for copy/duplicate record,1 for insert ,b2 for delete, 3 for update.
Now the link which would be carrying the copy record simply connect it to a transformer where declare a stage variable that would be incremented by 1.
Next in the field derivation write as CONCAT(string,'Initcaps(a'),'aa',svarcount,'')

1 Answers1