Articles in this section

See more

Schema Mapping - Key Columns

Avatar
Tom Sherwood
  • Updated
Follow
  • Key Columns are used to uniquely identify a dataset. They are required to ensure that data is correctly overwritten.
  • Only datasets where all key columns match will be overwritten.
  • Only columns that are defined as a 'dimension' in the Destination system can be used as key columns.

 

STEPS FOR SETTING KEY COLUMNS

  1. From the Connect Element, select the relevant Datastream.
    Datastreams_-_Select_Datastream_cropped.png 
  2. Go to the Datastream's Schema Mapping screen.
    Click_Schema_Mapping.png
  3. Set the 'Key Column' switch to green for the column you wish to be key.
    Switch_to_Key_Column.png
    In this case, "account_Id" is now a Key Column.
  4. Save mapping.

Related articles

Comments

0 comments

Article is closed for comments.