Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

Informatica - Unix Problem

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Informatica - Unix Problem
# 1  
Old 11-19-2007
Informatica - Unix Problem
hi guys,

I have to ftp an empty text file dim_trigger.txt form 1 server to another. The target server is mtiftp and i have defined the username and password.
Below is the shellscript thats in a file called dim_trigger.ksh
#!/bin/ksh
#
# FTP Bo trigger
#

HOST= 'mtiftp'
USER= 'CORP\nbsvd7l'
PASSWD= 'af$2Y58q'

ftp -n -v $HOST
quote USER $USER
quote PASS $PASSWD
cd /apps/informatica/msrvdev/TriggerFiles
put dim_trigger.txt
close
bye


Now dim_trigger.ksh is in apps/informatica/msrvdev/SH. the text file dim_trigger.txt is in apps/informatica/msrvdev/TriggerFiles

I have a command task that calls the shell script using the command touch /apps/informatica/msrvdev/dim_trigger.ksh. But that doesnt seem to work.


Thanks for all your help in advance!
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Code for Reading XML from Informatica

Hello , Can any one provide a code which can take XML input and have the tags in a seperate file.? (5 Replies)
Discussion started by: Si7798
5 Replies

2. UNIX and Linux Applications

Informatica Expression for INITCAP Question

Hi Team I am using below expression function in INFORMATICA 9.5 to make initial letters as CAPS . Output : Before After APPLICATIONS --> Applications SP TERMS --> Sp Terms I want output to be as SP Terms Please let me know what expression will satisfy my... (1 Reply)
Discussion started by: Perlbaby
1 Replies

3. UNIX and Linux Applications

UNIX help with informatica

Guys, I have a requirement.Please suggest the way i can : A script is being used to generate a file and send a mail to a source team if the feed for informatica jobs have not reached the server. If the file has not reached the server,the informatica jobs touch 0 byte file after 3 hours and... (2 Replies)
Discussion started by: aliva Dash
2 Replies

4. Shell Programming and Scripting

UNIX/Perl script to call informatica source counts

Hi Guys, I am trying below condition . We are using Informatica 9.5 and scheduling certain informatica mapping on set timings .But we are not sure whether the database source table are latest or not .Since its gets updated on daily basis and not sure when it completes.Can we write any unix/perl... (1 Reply)
Discussion started by: Perlbaby
1 Replies

5. UNIX for Dummies Questions & Answers

Unix coding for triggering informatica

Hi, I have very little knowledge with unix and pmcmd. I need help with a issue. I have to see whether a file has been dropped in a particular location/path. If the file dropped I have to check the last modified time, which should be greater than 8pmEST the prior day. If the file has been... (4 Replies)
Discussion started by: redwolves
4 Replies

6. Shell Programming and Scripting

UNIX script to check file and start the informatica server

Hi Rockers, I hope u r dng good one. I have a one question is in unix with informatica . I need a unix script to check whether particular file exists in the folder , If it means we have a informatica server , so we can start the informatica server by accessing that file. Every week we have... (0 Replies)
Discussion started by: gurukrishnan
0 Replies

7. UNIX for Advanced & Expert Users

automation of Informatica jobs using Unix

1.How will you do automation of Informatica jobs using Unix ? 2. How u run workflow from Unix? :) (2 Replies)
Discussion started by: kamesh83
2 Replies

8. UNIX for Dummies Questions & Answers

Call unix script through informatica mapping

hi, i want to call unix script from transformations used in informatica mapping? can we do it in any way? Please reply ASAP. We cant use Storep procedure transformation Thanks in Advance nishith (0 Replies)
Discussion started by: Nishithinfy
0 Replies

9. Shell Programming and Scripting

connecting to oracle thro informatica

Hi I have a shell script which is running fine in unix. But if i call the shell script thro informatica workflow post session command task it is not giving me the sum(amount) to a output text file The sql_configh.sh file has uid@db/pwd script_path="/path" cd $script_path connstr=`grep... (1 Reply)
Discussion started by: ksmbabu
1 Replies
Login or Register to Ask a Question

LEARN ABOUT OSX

mount_ftp

MOUNT_FTP(8)						    BSD System Manager's Manual 					      MOUNT_FTP(8)

NAME

     mount_ftp -- mount a FTP filesystem

SYNOPSIS

     mount_ftp [-i] [-o options] ftp://host[:port][/path] node

DESCRIPTION

     The mount_ftp command mounts a FTP-enabled server directory at ftp://host[:port][/path] at the mount point indicated by node.

     If the -i option is not used, all the required information to establish a login to the remote server must be available in the ftp URL,
     including username & password if needed.

     The user ID for all files and folders is set to the user's real user ID. The group ID for all files and directories is set to unknown, and
     the permissions default to read and execute for user, group and other.

     The options are:

     -i      Interactive mode, you are prompted for the username and password if you did not supply one in the url.

     -o      Options passed to mount(2) are specified with the -o option followed by a comma separated string of options. See the mount(8) man
	     page for possible options and their meanings. The rdonly option will be set even if it was not specified because mount_ftp does not
	     allow files to be opened with write access on servers.

     ftp://host[:port][/path]
	     The FTP-enabled server directory to mount as a volume. If port is not specified, then port 21 is used. If path is not specified, then
	     the path "/" is used.

     node    Path to mount point.

EXAMPLES

     The following example illustrates how to mount the FTP-enabled server directory ftp.apple.com/ at the mount point /Volumes/mntpnt/

	   mount_ftp ftp://ftp.apple.com/ /Volumes/mntpnt/

SEE ALSO

     mount(2), unmount(2), mount(8)

HISTORY

     The mount_ftp command first appeared Mac OS X Version 10.2.

RETURN VALUES

     0			mount_ftp successfully mounted the server directory.

     [ENOENT]		The server directory could not be mounted by mount_ftp because the node path is invalid.

     [ENODEV]		The server directory could not be mounted by mount_ftp because it is not FTP-enabled or because it does not exist, or
			because node does not have proper access.

     [ECANCELED]	The server directory could not be mounted by mount_ftp because the user did not provide proper authentication credentials.

BUGS

     mount_ftp only supports mounting read-only.

Mac OS X							   June 6, 2003 							  Mac OS X