Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Administrator H2L
  • All Products

Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Getting started with Informatica Intelligent Cloud Services on Google Cloud Platform

Getting Started with Informatica Intelligent Cloud Services on Google Cloud Platform

Getting Started with Informatica Intelligent Cloud Services on Google Cloud Platform

Back Next

Step 4. Create a mapping to load a CSV file into Google Cloud Storage

Step 4. Create a mapping to load a CSV file into Google Cloud Storage

The
Data Integration
 Mapping Designer allows you to define data integration flow in a visual designer interface. It starts from defining the data source to read data from, applying transformations based on your requirements on that data set, and then writing the resulting data set to the data target.
In this step, you load a CSV file from the flat file directory configured in flat file connection and write it to Google Cloud Storage. Please download the CSV file and place it in the flat file directory.
For information about transferring files to Google Compute Engine, see this GCP guide.
If you still have the
Administrator
 service open, click
Administrator
 next to the Informatica logo in the top left corner of the screen. Then select
Data Integration
 from the menu.
  1. In
    Data Integration
    , click
    New
     to open the
    New Asset
     dialog box.
  2. In the
    New Asset
     dialog box, click
    Mappings
     in the menu on the left, select
    Mapping
    , and click
    Create
    :
    In the New Asset dialog box, the Mappings option is the second option in the menu on the left. When you click Mappings, you can select either a mapping or at-scale mapping. In this image, "Mapping" is selected. The Create button appears at the bottom of the dialog box next to the Cancel button.
  3. When the mapping opens, enter the mapping name in the
    Name
     field:
    When you create a mapping, the Mapping Designer displays a new mapping with a Source and Target transformation. The mapping properties appear below the canvas. The Name field is the topmost property.
  4. Click the Source transformation in the canvas.
  5. On the
    General
     tab, update the name of the Source transformation to reflect the actual object.
    In this case, the source is a CSV file.
  6. Click the
    Source
     tab, and perform the following steps:
    1. In the
      Connection
       field, select the flat file connection that you created.
    2. Click
      Select
       next to the
      Object
       field to select the CSV file.
      IICS treats flat files as CSV by default. You can change the formatting by clicking
      Formatting Options
      .
    3. Optionally, click
      Preview Data
       if you want to view the first few rows of the data file.
    The Source tab of the Source transformation displays source details such as the connection, source type, and source object. In this image, the connection is a flat file connection, the source type is a single object, and the source object is the CSV file.
  7. Click the Target transformation in the canvas.
  8. On the
    General
     tab, update the name of the Target transformation to reflect the actual object.
    In this case, the target is Google Cloud Storage.
  9. Click the
    Target
     tab, and perform the following steps:
    1. In the
      Connection
       field, select the Google Cloud Storage V2 connection that you created.
    2. Click
      Select
       next to the
      Object
       field to create the target file.
    3. Select
      Create New at Runtime
      .
    4. In the
      Object Name
       field, enter the name of the target file that will be created.
    5. In the
      Path
       field, enter the name of the Google Cloud Storage bucket where the file will be stored:
      In the Target Object dialog box, the target object is set to "Create New at Runtime." The object name is the name of the target file to be created, and the path is the Google Cloud Storage bucket where the target file will be stored.
      For information about creating Google Cloud Storage buckets, see this GCP guide.
    6. Click
      Formatting Options
      , select
      Flat
       for the format type, and then click
      OK
      :
      The Formatting Options dialog box contains a field for the format type and properties that vary based on the format. The Format Type field appears at the top of the dialog box.
  10. Click
    Save
    .
  11. Click
    Run
     in the top right corner of the screen:
    The Run button appears in the top right corner of the Mapping Designer next to the Save button.
  12. Select the runtime environment, and then click
    Run
    :
    When you run the mapping, the Run dialog box appears. The Runtime Environment field appears at the top of the dialog box. The Run button appears in the bottom right corner between the Next and Cancel buttons.
  13. Click
    My Jobs
     to open the job activity page:
    The My Jobs page shows the jobs that you have run and the location, start time, end time, rows processed, and status for each job. In this image, the CSV to Google Cloud Storage mapping is the only job displayed. Its status indicates that the job completed successfully.
The target file is created in the Google Cloud Storage bucket:
The Google Cloud Storage bucket details show that the new target file has been created in the bucket.
For more information about creating mappings, see the
Data Integration
 Mappings guide.
0 COMMENTS
We’d like to hear from you!