Hi, My requirement is i want to capture the changed data from Oracle database into Redshift. My source tables not have any timestamps, so how can i do a CDC without transferring the whole source table into Redshift. I want to use Oracle redo/Archive logs in Matillion. Can we do this? If yes, please help me with some guided example or article.
1 Community Answers
Kalyan Arangam —
We currently do not support CDC via redo/archive logs. This is on our roadmap and may be available in a couple of releases. Please look out for announcements in our release notes or our YouTube channel.
For now, your only option is to pull the complete table across.