How can I compare records already in the entity against records in an input file?
F
Fathia Jama
a créé un sujet
sur un an il y a
How can I compare records already in the entity against records in an input file?
Meilleure réponse
F
Fathia Jama
a dit
sur un an il y a
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 commentaire
F
Fathia Jama
a dit
sur un an il y a
Réponse
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
Voir tous les 177 sujets