You can edit an import’s mapping and other configuration details at any time while previewing the data.
To adjust general import properties like the Target dimension, click the Configuration button. Use the Import Configuration window to make changes, then click OK.
Import Option – Choose Update or Replace. An Update will update existing data and add any new data included in the import file. A Replace clears existing data for all of the User Controlled Attributes that belong to the import’s Target dimension then adds data from the import file to the applicable attributes. Care should be taken when using a Replace since it removes data for all of a dimension’s User Controlled Attributes even if the attributes aren’t included in the import file. If there is existing data you don’t want to lose, then set the import configuration to Update instead of Replace. See also When To Do An Update Vs. When To Do A Replace For Your Master Data Imports.
Target Dimension – The Target dimension is the one with the attribute(s) that will receive imported data. User Controlled Attributes from that dimension will be available to select when you map imported data to Stratum.
Header Rows In File – Specify how many header rows are in the import file. Header rows contain descriptive details that aid you in mapping but do not get imported. For example, the rows contain dimension names, descriptions, or attribute names.
Use the provided drop-down selection lists in the preview to adjust mapping for each column in the import.
Ignore – For any columns you don’t want considered, select Ignore.
Dimension – Choose Dimension for column that contains the dimension key values, then use the Select A Target drop-down list to select the name of the Target dimension for the data.
Attribute – Choose Attribute for columns that contain attribute data (values), then use the Select A Target drop-down list to select the name of the Target attribute for the data.