How can I compare records already in the entity against records in an input file?
F
Fathia Jama
started a topic
over 2 years ago
How can I compare records already in the entity against records in an input file?
Best Answer
F
Fathia Jama
said
over 2 years ago
This will depend on whether your entity is a Basic, ID Matched or Fuzzy. For Basic or ID Matched entities, the ID will be preserved through the Certification Process,so you will be able to use the ID in a SQL statement to look for differences between the data sets (unless you ask xDM to generate an ID).
For a Fuzzy entity, the Golden ID is always generated by xDM, so you will need to use either Source Records or Master Records which hold the Publisher ID (Publisher Code) and Source ID.
The answer you're looking for will also depend on what Record Types you're trying to compare. Take a look at the links above, as can be seen in the validation phase of the certification process, you may find that certain records that are rejected by your data quality constraints (so they won't become golden records) but are still retained in source data as errors.
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
This will depend on whether your entity is a Basic, ID Matched or Fuzzy. For Basic or ID Matched entities, the ID will be preserved through the Certification Process,so you will be able to use the ID in a SQL statement to look for differences between the data sets (unless you ask xDM to generate an ID).
For a Fuzzy entity, the Golden ID is always generated by xDM, so you will need to use either Source Records or Master Records which hold the Publisher ID (Publisher Code) and Source ID.
The answer you're looking for will also depend on what Record Types you're trying to compare. Take a look at the links above, as can be seen in the validation phase of the certification process, you may find that certain records that are rejected by your data quality constraints (so they won't become golden records) but are still retained in source data as errors.
Fathia Jama
How can I compare records already in the entity against records in an input file?
This will depend on whether your entity is a Basic, ID Matched or Fuzzy. For Basic or ID Matched entities, the ID will be preserved through the Certification Process,so you will be able to use the ID in a SQL statement to look for differences between the data sets (unless you ask xDM to generate an ID).
For a Fuzzy entity, the Golden ID is always generated by xDM, so you will need to use either Source Records or Master Records which hold the Publisher ID (Publisher Code) and Source ID.
The answer you're looking for will also depend on what Record Types you're trying to compare. Take a look at the links above, as can be seen in the validation phase of the certification process, you may find that certain records that are rejected by your data quality constraints (so they won't become golden records) but are still retained in source data as errors.
Fathia Jama
This will depend on whether your entity is a Basic, ID Matched or Fuzzy. For Basic or ID Matched entities, the ID will be preserved through the Certification Process,so you will be able to use the ID in a SQL statement to look for differences between the data sets (unless you ask xDM to generate an ID).
For a Fuzzy entity, the Golden ID is always generated by xDM, so you will need to use either Source Records or Master Records which hold the Publisher ID (Publisher Code) and Source ID.
The answer you're looking for will also depend on what Record Types you're trying to compare. Take a look at the links above, as can be seen in the validation phase of the certification process, you may find that certain records that are rejected by your data quality constraints (so they won't become golden records) but are still retained in source data as errors.
-
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 276 topics