Importing data is the final step in importing product and pricing data into the Product Data Warehouse (PDW) Catalog.
Before you can import data into the PDW, you need to complete the following tasks:
During import, PDW creates product records for all of your data sources in the following way.
The table below represents your data source:
The top row holds the five data elements defined for this data source.
Each column below the first row contains the data element values for each product from your data source.
Every row after the first row then equals one product record.
|
Short Name |
Vendor Description |
UPC |
Cat# |
List Price |
|
Lev |
Receptacle |
123456789012 |
5252i |
6.36 |
|
Syl |
IPS Elbow |
345678901234 |
646372e |
10.00 |
|
ABC |
Pipe Cmpnd |
098765432109 |
333388 |
5.55 |
When you run an import, the PDW Catalog reads your data source, one record at a time, and then assigns each record a product record ID.
The table below then represents the PDW Catalog upon completion of the import.
The first column contains the assigned product record IDs.
Each row is one product record.
|
Product Record ID |
Short Name |
Vendor Description |
UPC |
Cat# |
List Price |
|
508394 |
Lev |
Receptacle |
123456789012 |
5252i |
6.36 |
|
508395 |
Syl |
IPS Elbow |
345678901234 |
646372e |
10.00 |
|
508396 |
ABC |
Pipe Cmpnd |
098765432109 |
333388 |
5.55 |
You can use the Preview Report to view each new record.
See Also:
Viewing the PDW Preview Report
Importing I2 Data into PDW