Product Requirements

Objective


Migrate the product information from a customer’s CSV file into your Pricefx partition through the use of IntegrationManager templates while properly mapping the CSV columns into the correct data structure and assigned attributes.

Resources


Use the following data sources and structures for this task:

  • Master Data table

o Product Master

  • Product Extension table:

o One or more extension tables as needed

  • CSV Data:

o Product CSV file
o Product Costs CSV file
o UOM CSV file

Data Layouts


There are multiple files related to this requirement and below are the layouts of the CSV files.
Layout of the Products CSV file:

  • Product ID

  • Product Name

  • Unit

  • Currency

  • Base Qty

  • UOM

  • Industry

  • Business Unit

  • Product Type

  • Manufacturing Type

  • Product Group

  • Product Line

  • Competitiveness

  • Sub Product

  • EAN

  • Packaging Type

Layout of the Product Costs CSV file:

Product ID

  • Cost

  • Valid From Date

  • Valid To Date

  • Currency

  • Dependency Level Name

Layout of the UOM CSV file:

  • Product ID

  • Additional UOM

  • Conversion Rate

 

Acceptance Criteria


Develop a data integration solution using the IM template(s) that successfully migrates the CSV data into the appropriately defined and structured table or tables in the partition. Your solution should contain the following components:

  1. PlatformManager/IntegrationManager:

a. IntegrationManager Instance and companion SFTP server
b. Appropriate SFTP folder(s)
c. Utilization of case study partition
d. Correct metadata definition for all of the customer’s Product data
e. Utilization of IM template(s) to create:
i. Mappers
ii. Routes
iii. Connections

  1. Partition:

a. Configured structures
b. Populated structures