Ask Your Question
0

How to add fields to CDC record

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

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
1

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

iamontheinet gravatar image

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

Hi!

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

Comments

1

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 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 436 times

Last updated: Sep 07