Data Source Requirements
- Ioana Kocurova
Objective
Migrate the customer’s multiple CSV files into Pricefx datasources to support datamart development. Focusing on the proper mapping of the CSV columns into the correct data structure and assigned attributes.
Resources
Use the following data sources and structures for this task:
• Data Source Structures:
o UOM
o Currency o Calendar
• CSV Data:
o DS_Calendar CSV
o DS_Currency CSV
o DS_UOM CSV
Data Layouts
There are multiple files related to this requirement and below are the layouts of the CSV files.
Layout of the Calendar CSV file: • Cal Date • Calendar Week • Calendar Month • Calendar Qtr • Calendar Year
Layout of the Currency CSV file:
• Valid From
• Exchange Rate
• Valid To
• CCY From
• CCY To
Layout of the Currency CSV file:
• UOM From
• UOM Conversion Factor
• UOM To
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. SFTP folder(s)
c. Utilization of case study partition
d. Correct metadata definition for all transaction data
e. Utilization of IM template(s) to create:
i. Mappers
ii. Routes
iii. Connections
2. Partition:
a. Configured structures
b. Populated structures