Fully Qualified Keys

Use Fully Qualified Keys (FQK) to avoid key conflicts when data from different sources are harmonized in the Data 360 data model.

• Data Interpretation with Fully Qualified Keys
  Fully qualified keys help to accurately interpret data ingested from different sources. Each data stream is ingested into Data 360 with its specific keys and attributes. When multiple data streams are harmonized into a single data model object (DMO), the various keys can conflict and records can have same key values. Fully qualified keys avoid conflicts by adding key qualifier fields and interpreting the data accurately.
• Best Practices for Fully Qualified Keys
  Use fully qualified keys (FQKs) to help Data 360 accurately interpret data ingested from different data sources.
• Fully Qualified Keys in Data Objects
  Data 360 adds key qualifier fields to data lake objects (DLOs) and data model objects (DMOs). Key qualifier fields can also be added when you create object relationships and object mappings between DLOs and DMOs.
• Fully Qualified Keys for Query API
  Use Query API to query data in Data 360. Identify key qualifier fields in a data lake object with the Data 360 Metadata API, and include key qualifier fields in all table joins to get accurate results.
• Configure a Key Qualifier Field
  After creating a data stream, add key qualifiers to your data lake object (DLO) fields to create fully qualified keys (FQK). Configure key qualifiers for all DLO fields that contain either a primary or foreign key. You can add up to 20 active key qualifiers. A key qualifier is active when it's used for a DLO field. Data 360 automatically adds and removes key qualifiers to and from data model object (DMO) fields. You can't edit these system fields.
• Remove or Delete a Key Qualifier
  To reduce clutter and avoid reaching your org's limit for key qualifiers, remove and delete unnecessary key qualifiers from the system. To delete a key qualifier, you must first remove it from all the data lake object (DLO) fields that it’s associated with and then delete it. You can also just remove a key qualifier from a DLO field but not delete it from the system. Removing a key qualifier from a DLO field can potentially affect the accuracy of calculated insights, segments, activations, and API queries.