Import mapping works by identifying all records with unique layout keys, and then mapping each field of a record to a pre-defined PDW metadata item. The system uses the layout key to merge or match the items you are importing to those items that have been provided by another data provider to prevent duplicates in the PDW Catalog. In addition, for any items that did not match the layout key, the system make an additional pass through the data to determine if the initial no match items match to the secondary key.
Note: Do not merge metadata values from a primary data source with a vendor disk or some other data source. Instead create metadata items specific to each primary data source, with the exception of vendor disks.
You can define any pricing zones that may exist for products. Pricing zones hold multiple price sheets that apply to one product distributed across multiple branches. You define pricing zones when a vendor sends multiple disks for the same product. On each of these disks are different pricing sheets for the product that you distribute from multiple branches. Pricing zones let you keep the product in the same price line but still assign the correct pricing sheet to it. Set up pricing zones by defining a price sheet within the system for each branch that contains the product or defining all sheets that belong to one zone.
Before you can import data from electronic files into the Product Data Warehouse (PDW), you need to define the layout of the import record and then map each field in the layout to a metadata item in the PDW.
Use Import Map Maintenance to perform the following tasks:
Defining the layouts of the electronic files you use to populate the PDW.
Mapping the imported fields of data to the associated metadata items in the PDW.
Note: You only need to perform this setup once for each source file before importing the data into the PDW. Each time you import data from a designated source, the system uses the corresponding map. You can edit import maps, as needed.
Additionally, make sure you have your metadata items defined prior to setting up your import map layouts.
Use the following screens to complete the layout and mapping functions for importing data:
PDW Import File Layout - Use to define the import layout of data.
PDW Translation Table - Use to translate entire fields of data.
PDW Import Map Maintenance - Use to name and map data.
PDW Conversion Table - Use to convert individual words in a field.
See Also: