Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm setting up a new DW with Full load and CDC tasks. When I try to add a new mapping for the CDC task the __ct tables are not showing up in the list of tables for the corresponding schema. __ct tables are present in the landing database (SQL Server 2019) and Replicate is processing and storing the changes. Already tried recreating the Project, but no luck.
Compose 2023.11.0.159
When setting up a mapping in Compose, you do not select the _CT tables. You select the standard table. The CDC task will auto-adjust the ELT process to read from the _CT tables.
When setting up a mapping in Compose, you do not select the _CT tables. You select the standard table. The CDC task will auto-adjust the ELT process to read from the _CT tables.
Thanks @TimGarrod.