General –

• 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.

Note: Once you have done a few imports, Master Data Import learns about your import data habits and can do some automatic configuration and Data Mapping. When that happens, the Import Configuration window is bypassed. You can open it anytime by clicking the Configuration button in the Data Mapping window.

File Data – Make selections about how your file is set up. Use Header Rows In File to 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 row(s) contain dimension names, descriptions, or attribute names.