Informatica Cloud: How To Read Flat Files

This page explains how to create a connection to a directory from which you can read flat files in Informatica Cloud.

(1) How to create a connection to a directory

    1. Go to the Conftion Tab and choose ‘Connection’

 

  1. Add parameters (Connection Name, Type, Runtime Environment, Directory, Data Format and Code Page)

 

 

 

 

 

 

 

 

 

 

 

(2) How to Configure Source in the Mapping

  1. Go to Mappings and drag the Source stage into the canvas.
  2. Rename the Source
  3. Add connection. To read a specific flat file, choose Single Object as Source Type and select the source object
  4. (Optional) Under Advanced, we can set Tracing Level (Terse, Normal, Verbose Initialization, Verbose Data). This will determine what information goes to the session log file.
  5. Default data type for the flat file is string. We can edit the metadata. In this example, Transaction_Date is changed to datetime and Id is changed to integer.
  6. (Optional) We can also set the number of partitions to process data in parallel.

 

ETL
Running Jobs with Informatica Cloud REST API

Informatica Cloud offers REST API for us to interact with the platform programmatically. At this point in time, the latest official reference is found here. In this post, we are going to use Python to trigger jobs through API. Triggering a job is a 2-step process. We need to authenticate …

ETL
Tips and Troubleshooting For Uploading CSV to Database In Talend

There will be time when you want to upload a big csv file (with many rows and hundreds of columns) to a relational database table. Talend Open Studio is an open source ETL tool that I use regularly to do odd jobs like that. I like using it because it …

ETL
How To Rename Mapping Job In Informatica Cloud

Mappings are where all the magic happens in Informatica Cloud. When I started using it, it took me a while to work out how to rename a mapping job. Since then, a few people asked me the same question. So, I decided to write about it. This is probably the …