Files provided in the shared path can be read directly through 'FTP' connection option available in Informatica. In Workflow Manager, we can see this option under the Connections menu.
Mappings can be developed as such developed for flat file sources. Before configuring the session, the FTP connection should be defined as shown below
A Name for the connection, Credentials and the Hostnames are required.
Once the connection is defined, the connection name can be referred in the session, as shown below.
Once the connection type is selected as FTP and the connection name is selected under value, the file name should be given in the connection properties. The boxed icon shown above should be clicked to provide the same.
Remote filename should be provided as shown above.
There is an option 'Is Staged' which is useful to FTP the file to the local path and the file reading can be started. This option is also helpful when the file should be archived after the ETL process for future reference.
A Name for the connection, Credentials and the Hostnames are required.
Once the connection is defined, the connection name can be referred in the session, as shown below.
Once the connection type is selected as FTP and the connection name is selected under value, the file name should be given in the connection properties. The boxed icon shown above should be clicked to provide the same.
Remote filename should be provided as shown above.
There is an option 'Is Staged' which is useful to FTP the file to the local path and the file reading can be started. This option is also helpful when the file should be archived after the ETL process for future reference.
No comments:
Post a Comment