How to add fields to CDC record

OracleCDC

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

KateF
28 ●4 ●6 ●9

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

iamontheinet

2045 ●4 ●11 ●33

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

Comments

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 ( 2020-09-08 11:22:12 -0500 )edit

add a comment

Question Tools

1 follower

Stats

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

Seen: 436 times

Last updated: Sep 07

How to add fields to CDC record edit

1 Answer

Comments

Question Tools

Stats

Related questions

How to add fields to CDC record