Dear all,
i have a source table contain : CustId, Fname/Lname/DOB/Street/ Valid colmn or not.
So, i need to develop the cdc logic on IDQ in order to detect the change of Validation status for each customer .
Cust_id | Fname | Lname | DOB | Street | Valide_Fname | Valide_Lname | Valide_DOB | Valide_Street | Date |
1 | Ismahane | SILHADI | 10/10/1900 | A | Valid | Valid | Invalid | Invalid | 23/02/2021 |
Cust_id | Fname | Lname | DOB | Street | Valide_Fname | Valide_Lname | Valide_DOB | Valide_Street | Date |
1 | Ismahane | SILHADI | 10/10/1990 | Algeria | Valid | Valid | Valid | Valid | 24/02/2021 |
Thank you so much fo your help
BR
Hi SILHADI,
You can try using Update Strategy Transformation in IDQ mappings and see If you can implement above Change Data Capture Scneario. Document reference for Update Strategy transformation:
Update Strategy Transformation