Use the Warehouse Target notebook to specify how the Data Warehouse Center agent site will access the flat file to be included in the warehouse target.
To specify connection information for a warehouse target:
Click the Advanced button. The Advanced window opens.
The Advanced window will look different depending upon the type of file you have chosen to import.
If you have chosen to import a file that is local to the agent:
Optional: In the Pre-Access Command field, type the command that you use to access a local file. The command varies according to the product that you are using.
Optional: In the Post-Access Command field, type the command you use after you access the file. The command varies according to the product that you are using.
If you have chosen to import a file that is to be copied from an FTP site:
In the System Name field, type the fully qualified name of the FTP host. If the name server that is local to the agent site can resolve the host domain qualifiers, you can type the host name only.
In the User ID field, type the user ID used to access the FTP site where the file resides.
In the Password field, type the password used to access the FTP site. The password is case sensitive.
In the Verify Password field, type the password again to verify the password you typed in the Password field. Because the agent uses the user ID and password during batch processing, you cannot fix errors in the user ID and password at run time.
Click OK to save your changes and close the Advanced window.