Consider the following rules and guidelines for FTP/SFTP connections:
•Informatica Intelligent Cloud Services does not lock the target file while writing to the file. To prevent data corruption, verify that only one task writes to a target file at any given time.
•If metadata in the local target file and remote target file are different, Informatica Intelligent Cloud Services overwrites the metadata of the remote target file with the local target file at run time.
•To find the row count of rows loaded into the local target file, open the job details from the All Jobs or My Jobs page.
•In Windows, you cannot select FTP/SFTP directory on a mapped drive through the Browse for Directory dialog box. You can access a network directory by browsing My Network Places. You can also enter the directory with the following format:
\\<server_name>\<directory_path>
If the Browse for Directory dialog box does not display My Network Places, you might need to configure a network login for the Secure Agent service.
•Error messages for FTP/SFTP connections might only reference FTP or SFTP. Read any error message that references FTP or SFTP as an error message for an FTP/SFTP connection.