Google Cloud Storage V2 Connector > Mappings for Google Cloud Storage > Mappings in advanced mode example
  

Mappings in advanced mode example

You work for one of the largest pharmaceutical company that maintains millions of records in their pharmacy database. The company has more than 10,000 employees working at 500 locations across the globe. The company has a very large IT infrastructure and about 20 TB of information gets downloaded on daily basis from the Internet.
To avoid performance, scalability, and high cost challenges, the company plans to port its entire data from its operational data stores to Google Cloud Storage within a short span of time. Create a mapping in advanced mode to achieve faster performance when you read data from the operational data stores and write data to the Google Cloud Storage target.
    1In Data Integration, click New > Mappings > Mapping.
    2In the Mapping Designer, click Switch to Advanced.
    The following image shows the Switch to Advanced button in the Mapping Designer:
    In the Mapping Designer, the header includes the Switch to Advanced button.
    3In the Switch to Advanced dialog box, click Switch to Advanced.
    The Mapping Designer updates the mapping canvas to display the transformations and functions that are available in advanced mode.
    4 Enter a name, location, and description for the mapping.
    5On the Source transformation, specify a name and description in the general properties.
    6On the Source tab, perform the following steps to provide the source details to read data from the source:
    1. aIn the Connection field, select the required source connection.
    2. bIn the Source Type field, select the type of the source.
    3. cIn the Object field, select the required object.
    4. dIn the Advanced Properties section, provide the appropriate values.
    7In the Target transformation, specify a name and description in the general properties.
    8On the Target tab, perform the following steps to provide the target details to write data to the Google Cloud Storage target:
    1. aIn the Connection field, select the Google Cloud Storage V2 target connection.
    2. bIn the Target Type field, select the type of the target.
    3. cIn the Object field, select the required object.
    4. dIn the Operation field, select the required operation.
    5. eIn the Advanced Properties section, provide appropriate values for the advanced target properties.
    9On the Fields tab, map the source fields to the target fields.
    10Click Save > Run to validate the mapping.
    In Monitor, you can monitor the status of the logs after you run the task.