We were able to successfully test the consistent set cdc for initial loads in 12.2.x. We are using SCD as the LKM. We ran into issues when we have multiple sources in a mapping to load a single dimension table. Here is the scenario:-
The last updated date is updated for a child when the parent record is not touched. In this case, the journal table for the parent is empty while the child table has the updated record. This scenario could happen for a parent record when it is updated is in the journal table while the child is not updated and empty in the journal table. In either of the cases, the target is not getting the updated information.
How is it possible to trigger an update to the parent or child in either of the scenarios so that all the sources will have corresponding journal data so that the target dimension table is populated with the updates?