How are child records selected when parent records are manually merged?
F
Fathia Jama
started a topic
over 2 years ago
How are child records selected when parent records are manually merged? Can I ask to collect all child records or filter based on an semQL expression (more recent, different from null,...)?
Best Answer
F
Fathia Jama
said
over 2 years ago
You should be careful to be explicit about MD records and GD records in your thinking.
Let's say the starting point is 2 Golden parent records each with 2 Master records. And each MD parent record has 2 MD child records.
When those 2 GD Parent records get manually merged, the child records have the potential to get merged. It will depend on the match rule for that entity. In my example here, there are 8 MD child records. So the first thing know for sure is that all 8 MD records will be children of the 1 GD Parent record. But we don't know how many child GD records there will be. There could potentially be anywhere from 1 to 8 child GD records.
Does it answer your question? (There are possibly more unusual situations to consider... but I tried to cover the main points.)
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
You should be careful to be explicit about MD records and GD records in your thinking.
Let's say the starting point is 2 Golden parent records each with 2 Master records. And each MD parent record has 2 MD child records.
When those 2 GD Parent records get manually merged, the child records have the potential to get merged. It will depend on the match rule for that entity. In my example here, there are 8 MD child records. So the first thing know for sure is that all 8 MD records will be children of the 1 GD Parent record. But we don't know how many child GD records there will be. There could potentially be anywhere from 1 to 8 child GD records.
Does it answer your question? (There are possibly more unusual situations to consider... but I tried to cover the main points.)
Fathia Jama
How are child records selected when parent records are manually merged? Can I ask to collect all child records or filter based on an semQL expression (more recent, different from null,...)?
You should be careful to be explicit about MD records and GD records in your thinking.
Let's say the starting point is 2 Golden parent records each with 2 Master records. And each MD parent record has 2 MD child records.
When those 2 GD Parent records get manually merged, the child records have the potential to get merged. It will depend on the match rule for that entity. In my example here, there are 8 MD child records. So the first thing know for sure is that all 8 MD records will be children of the 1 GD Parent record. But we don't know how many child GD records there will be. There could potentially be anywhere from 1 to 8 child GD records.
Does it answer your question? (There are possibly more unusual situations to consider... but I tried to cover the main points.)
Fathia Jama
You should be careful to be explicit about MD records and GD records in your thinking.
Let's say the starting point is 2 Golden parent records each with 2 Master records. And each MD parent record has 2 MD child records.
When those 2 GD Parent records get manually merged, the child records have the potential to get merged. It will depend on the match rule for that entity. In my example here, there are 8 MD child records. So the first thing know for sure is that all 8 MD records will be children of the 1 GD Parent record. But we don't know how many child GD records there will be. There could potentially be anywhere from 1 to 8 child GD records.
Does it answer your question? (There are possibly more unusual situations to consider... but I tried to cover the main points.)
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 274 topics