Ask Your Question

How to add fields to CDC record

asked 2020-09-03 15:53:24 -0600

KateF gravatar image

Hi, I have a requirement to inject fields into records coming from an Oracle CDC origin before I send them to the JDBC destination.

I need to inject two fields: a source name which will be a static string, the same for all records/tables, and a timestamp field.

Is this possible with the Field Mapper or some other processor? I'm just not understanding how to do it from the documentation.

Thanks, Kate

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2020-09-07 15:58:15 -0600

iamontheinet gravatar image

updated 2020-09-07 15:59:00 -0600


You can use Expression Evaluator for inserting / creating new fields for every record. For static field, just enter the text value and for timestamp you can use one of the time functions.

image description

Cheers, Dash

edit flag offensive delete link more



Thanks! For some reason I thought if I used the Expression Evaluator I had to map all the fields, but this worked great to just add the new fields I wanted.

KateF gravatar imageKateF ( 2020-09-08 11:22:12 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-09-03 15:53:24 -0600

Seen: 521 times

Last updated: Sep 07 '20