Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ameyy
Contributor
Contributor

How to handle "Deletes" from source using tDBSCD component.

How to handle "Deletes" from source using tDBSCD component.

I'm suing scd type 1 and target scd table is oracle

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hello,

If we understand your requirement very well, are you trying to track deleted rows from the source with scd? Actually, the SCD component doesn't support the delete action.

You could take a look at talend CDC strategy on the source system, which needs to change to report all rows that have had something happen to them (inserted updated deleted).

Best regards

Sabrina

 

 

View solution in original post

1 Reply
Anonymous
Not applicable

Hello,

If we understand your requirement very well, are you trying to track deleted rows from the source with scd? Actually, the SCD component doesn't support the delete action.

You could take a look at talend CDC strategy on the source system, which needs to change to report all rows that have had something happen to them (inserted updated deleted).

Best regards

Sabrina