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!
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. UNIX for Dummies Questions & Answers
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
3. UNIX for Advanced & Expert Users
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
4. Shell Programming and Scripting
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
5. UNIX for Dummies Questions & Answers
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
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
7. UNIX and Linux Applications
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
8. UNIX and Linux Applications
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
9. Shell Programming and Scripting
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
LEARN ABOUT OPENSOLARIS
let
let(1) User Commands let(1)
NAME
let - shell built-in function to evaluate one or more arithmetic expressions
SYNOPSIS
ksh
let arg...
ksh93
let [expr...]
DESCRIPTION
ksh
Each arg is a separate arithmetic expression to be evaluated.
ksh93
let evaluates each expr in the current shell environment as an arithmetic expression using ANSI C syntax. Variables names are shell vari-
ables and they are recursively evaluated as arithmetic expressions to get numerical values. let has been made obsolete by the ((...)) syn-
tax of ksh93(1) which does not require quoting of the operators to pass them as command arguments.
EXIT STATUS
ksh
ksh returns the following exit values:
0 The value of the last expression is non-zero.
1 The value of the last expression is zero.
ksh93
ksh93 returns the following exit values:
0 The last expr evaluates to a non-zero value.
>0 The last expr evaluates to 0 or an error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
ksh(1), ksh93(1), set(1), typeset(1), attributes(5)
SunOS 5.11 2 Nov 2007 let(1)