Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Al_gar
Contributor III
Contributor III

__ct tables not showing up in Qlik Compose

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

 

Labels (1)
1 Solution

Accepted Solutions
TimGarrod
Employee
Employee

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. 

View solution in original post

2 Replies
TimGarrod
Employee
Employee

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. 

Al_gar
Contributor III
Contributor III
Author

Thanks @TimGarrod.