DataStage

DataStage: Remove Leading & Trailing Lines in Flat File

When flat file has leading and trailing lines that are not part of the table, we can use the filter in the flat file stage to remove them. As an example, the file below has a leading and trailing lines. We want remove them with the flat file stage. Output Steps …

ETL

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 Go to the Conftion Tab and choose ‘Connection’   Add parameters (Connection Name, Type, Runtime Environment, Directory, Data Format and …