Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.

Click OK.

Add Sorter Transformation:

Drag and drop the Sorter transformation on the link between the Source and Target
transformations.

Note: Sorter transformation reads the first names of customers from the source and
sorts them alphabetically.
Select the Sorter transformation from the mapping canvas.

Module 7: Expression Macro and Dynamic Linking 275

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.
Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.

In General section of Sorter properties, retain the Name as Sorter.

From the properties pane, click Sort.

To add a new sort condition, click .

Enter the condition, as shown in the table below:

Field Name Sort Order
First_Name Ascending

To configure the target, from the mapping canvas, click the Target transformation.

276 Module 7: Expression Macro and Dynamic Linking

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.
Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.

In the General section of Target properties, retain Name as Target.

From the properties pane, click Target.

From the Connection drop-down, select XX_FirstName_LocalCSVFiles.

Retain Target Type as Single Object.

To select the target object, from the Object field, click Select.

Note: The Target Object window appears.

In the Target Object window, select Create New at Runtime.
Enter Updated_Data_%d_%m_%y.csv as File Name.

Note: The %d, %m, and %y will determine the date, month, and year respectively. This
timestamp also determines when it will create the file.
To enable time stamp feature, select Handle Special Characters.

Module 7: Expression Macro and Dynamic Linking 277

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.
Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.

Click OK.

Note: As you create a blank new file, you do not need to map the source and target
fields. Notice that the Operation is set as Insert by default.

To save the mapping, click Save.

Note: After you save the mapping, the mapping status (Valid or Invalid) is automatically
displayed next to the mapping name.
To run the mapping, click Run.

Note: The Run mapping window appears.

278 Module 7: Expression Macro and Dynamic Linking

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.
Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.

From Runtime Environment drop-down, select your secure agent group.

Note: The Runtime Environment name will be in format CDI-XX-FIRSTNAME.
Click Run.

Monitor Status:
To monitor the mapping status, from the Navigation pane, click My Jobs.

When the task completes, the status changes to Success.

On your local machine, go to C:\IICSLabFiles.

Verify that the Updated_Data_XX_XX_XX.csv file consist 15 rows that are sorted order
according to the First Name.

Module 7: Expression Macro and Dynamic Linking 279

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.
Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.

Note: XX_XX_XX is the date when the file is created.

This concludes the lab.

280 Module 7: Expression Macro and Dynamic Linking

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.
Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.

Module 8: Replication Task

Lab 8-1: Replicating Data to a Flat file
Overview:
A replication task replicates data from a source to a target.

Objective:
Create a replication task to replicate data to a CSV file
Scenario:
Ruby is concerned that the updated data on Salesforce Account object is not saved anywhere
for backup purposes. So, John suggests creating a replication task to load Account objects in
Salesforce to flat file.
Duration:
10 minutes

Tasks:
Create Replication Task:
Access your cloud trial account by clicking Launch in your option Menu. If the option
menu is labeled anything other than Launch, click the down arrow to the right and
click Launch.

Note: Follow this step, if you have navigated away from the login page.

Module 8: Replication Task 281

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.
 Copyright© 2019, Informatica and/or its affiliates.

Enter your login credentials and click Log In.

From the My Services window, select Data Integration.

282 Module 8: Replication Task

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.
Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.

To create a new asset, from the Navigation pane, select New.

In the New Asset window, select Replication Task, and click Create.

In the Task Name field, enter XX_FirstName_SFDCAccount_to_FF.

From Source Connection drop-down, select XX_FirstName_SFDCDeveloper.

Module 8: Replication Task 283

Unauthorized reproduction or distribution prohibited. Copyright© 2019, Informatica and/or its affiliates.