Configure a

synchronization

task to use the insert operation.

The source for the mapping is a MySQL connection that connects to the sales data. The MySQL object contains multiple source objects in the

synchronization

task.

The sales_record MySQL object includes the

Row_id

,

Order_id

,

Order_Quantity

,

Order_Date

,

Unit_Price

,

Region

, and

Product_Category

source fields.

The dim_product MySQL object includes the

Product_ID

,

Product_Name

, and

Load_Date

source fields.

Add a join condition between the source field in the sales_record object and the dim_product object to define the following relationship:

sales_record.Product_Category=dim_product.Product_ID

The target for the mapping is an Amazon S3 bucket. Specify the target connection as Amazon S3, the target object as the name of the delimited file into which you want to insert the data. Select the target operation as the insert operation.

Map the source fields to the target fields.

When you run the task, the

synchronization

application writes the collated source data to the target delimited file. If you specify the name of an existing file, the Secure Agent replaces all data in the file.

You can schedule the task for each requirement and save. Configure the advanced source and target properties on the

Schedule

tab and save.