[resolved] tOracleCDC and dynamic schema

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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