Ask Your Question
1

How to receive the entire row from Oracle CDC

asked 2019-07-02 05:11:35 -0500

cypnose gravatar image

updated 2019-07-03 04:19:23 -0500

I want to connect my Oracle DB to a file using StreamSets. I succeeded; in the file I get a SDC RECORD but I have only a ROWID and the data I've modified. So In order to recover the entire row I have to do a select. What is the best way to avoid this other select?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2019-07-02 12:30:45 -0500

metadaddy gravatar image

To receive the entire row without needing to issue a select query the pipeline, you need to configure Oracle LogMiner for full supplemental logging. See the Oracle CDC documentation on enabling supplemental logging.

edit flag offensive delete link more

Comments

Thanks a lot I is working ;)

cypnose gravatar imagecypnose ( 2019-07-03 04:19:05 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-02 05:11:35 -0500

Seen: 384 times

Last updated: Jul 03