topic [resolved] tOracleCDC and dynamic schema in Talend Studio

[resolved] tOracleCDC and dynamic schema

Anonymous — Sat, 16 Nov 2024 10:22:50 GMT

Hello,
I would like to know if it is possible to use a dynamic schema with the CDC oracle component. My problem is that my source structure table is not static, it changes a lot and is quite big (lots of millions of rows) and it will be great if i can get the changed rows without change every time the structure of my src table.
The Talend version is Big Data Entreprise 6.2.1
Oracle 11.2

Any help?

Thanks

Re: [resolved] tOracleCDC and dynamic schema

Anonymous — Tue, 20 Sep 2016 16:29:48 GMT

Talend real-time CDC relies on DB triggers. If your schema is changing then the triggers will be invalidated and your CDC will break.
Dynamic schema is not a good for your use case.

Re: [resolved] tOracleCDC and dynamic schema

Anonymous — Tue, 20 Sep 2016 16:37:45 GMT

Hello Amula,
Thank you for your reply, but it is a way tho do this ? maybe the mode cdc redo log ?
Regards

Re: [resolved] tOracleCDC and dynamic schema

Anonymous — Tue, 20 Sep 2016 16:50:57 GMT

im not sure ....if the supplemental logging dont break with schema changes then you should be ok i guess.