CDC should not update all target rows but only specific ones

[Ole_Dufour]

In order to deal with multiple target rows I have set the internal parameter "updateOneRow" to False(0).
The problem is that when using CDC all target rows get updated when a source table value changes.

Below I have summarized our current configuration. We have 2 source tables and one target table.

In the source database, one or more persons can be part of a family. When updating the Marriage date of a family, all of the Marriage date rows in the target table get updated. This is not what I want because a 'Child' has no marriage date...

How do I configure my CDC task if the marriage in the target for Persons should only be captured for persons having the role 'Spouse' ?
That means that the marriage date of persons in all other roles should be null, so Luc Lafarge who is a 'Child' shouldn't have a marriage date in the target table.

 *Source table 'Person'

ID	FirstName	Name	FamilyId	Role
1	Jean	Lafarge	4	Spouse
2	Valérie	Lafarge	4	Spouse
3	Luc	Lafarge	4	Child

*Source table 'Family'

ID	MarriageDate
4	10 oct 2005

 *Target table 'Person'

ID	FirstName	Name	MarriageDate	Role
55	Jean	Lafarge	10 oct 2005	Spouse
56	Valérie	Lafarge	10 oct 2005	Spouse
57	Luc	Lafarge	should be null !	Child

[OritA]

Hi,

Could you please open a case to our support team, with description of  your issue and send us the task diagnostic package (in case there is) and the above details.Based on the information we'll troubleshoot and solve your request. 

Thanks & regards,

Orit

[shashi_holla · Accepted solution]

Hi @Ole_Dufour 

Replicate doesn't handle the relationships or references between 2 tables. It's mainly for one-to-one replication only i.e., it will match the data exactly as we have on the source to the target.

But if you are looking to setup relationship between two tables then you would need to use Qlik Compose to perform the operation.

Thank you,