Microsoft SQL Server Connector Guide > Mappings and Mapping Configuration Tasks with Microsoft SQL Server Connector > Microsoft SQL Server Mapping Task Example
  

Microsoft SQL Server Mapping Task Example

To perform the insert operation from Microsoft SQL Server source to a flat file target perform the following steps:
    1. Click Design in the Informatica Cloud home page.
    2. Select Mappings from the menu.
    The Mappings tab appears.
    3. Click New to create a Mapping.
    4. Select the Source from the selection panel and configure the source properties. The following image shows details of the Source Properties page:
    select source for mapping
    5. Select the target from the selection panel and configure the target properties. The following image shows details of the Target Properties page:
    select target for mapping
    In the target object, you can create a target file or target object at run time. You can also select an existing object from the list. The following image shows details of the Target Object page: Create a target object at the runtime
    6. Map the source and target.
    Mapping
    7. Click save and run the mapping.
    After you run the task, the Monitor Log page appears where you can monitor the status of Mapping tasks.