Objective

Migrate the customer’s transactional history information from the supplied CSV file into your Pricefx partition 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: • Transactional History o Transaction Data Source • CSV Data: o Transactions Q1 2022 CSV file

Data Layouts

There are multiple files related to this requirement and below are the layouts of the CSV files.

Layout of the Transactions Q1 2022 CSV file: • Document ID • Unique ID • Trans Source • Customer ID • Product ID • Pricing Date • Packaging • Quantity • UOM Weight • Currency • Cost • Base Price • Segment Margin Adj • Global List Price • Local Adj • Local List • Volume Discount • Promotion Discount • Customer Discount • Freight Charge • Warehouse Adj

•Packaging Adj • Invoice Price • Rebates • Net Price • Pocket Price • Pocket Margin • Gross Margin • UOM • Gross Margin Pct • Total Costs

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:

2. Partition: