Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] tOracleCDC and dynamic schema

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

Labels (2)
3 Replies
Anonymous
Not applicable
Author

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
Not applicable
Author

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

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