Sponsored Content
Top Forums Shell Programming and Scripting Reg: Shell script ran using informatica Post 302146930 by sam99 on Friday 23rd of November 2007 04:30:37 AM
Old 11-23-2007
Reg: Shell script ran using informatica

Hi all,

I am not sure whether this is the right place to ask this question...Smilie

I am working in Informatica PowerCenter 8.1.1 tool and my server is on UNIX. I have got a shell script to copy files from one folder to another.

When I run the script directly from UNIX prompt it is taking 60 minutes.
But when I run the same script using Informatica command task it is taking only 15 minutes.

What may the reason for this performance boost??? As per my understanding in both cases script is running in the same enviornment...
Could anybody advice...???

thanks,
Sam
 

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

Reg sftp in shell script

Hi, I want to retrieve files from an sftp site and place it a directory in unix server. When I try to connect, it is asking password even if i hardcode it in the script.I want to automate the script. Could anyone tell me how to avoid password prompt. #!/bin/sh # sample automatic ftp script... (3 Replies)
Discussion started by: vidhya_vec
3 Replies

3. Shell Programming and Scripting

Help with Informatica Backend Shell Script

Request Any one of your to provide me a script which does the following in a single unix script. Basically Users will load data in SHARED LINK everyday, should write a UNIX SCRIPT which will ........ 1) Unix script should Open the LINK (FTP) 2) Each DIRECTORY in the link contains many... (0 Replies)
Discussion started by: informaticalabs
0 Replies

4. Shell Programming and Scripting

Linux script to check the informatica log

Hi, We are loading 100 + oracle tables using informatica. At the end of the run, we need to verify the informatica log to confirm the rows are loaded properly to target tables. There are so many detials included in the etllog. But,the part of the informatica log, linux script needs to look... (0 Replies)
Discussion started by: Maya_Pillai
0 Replies

5. Shell Programming and Scripting

Help with shell scripts for Informatica and mainframes

I am poor at scripting.Can any one help me write a script which parametrizes the script here . #!/bin/bash `rm file1.txt` lineCount=0 newRec=1 IFS=`echo "\n\c"` while read line do lineCount=$(($lineCount + 1)) #check is it a... (2 Replies)
Discussion started by: etldev
2 Replies

6. Shell Programming and Scripting

how to find whether a script ran or not

Hi, I have written a script and placed in an application and the script can be executed manually only. But somehow one of the method in the script is being called and bringing the application down. But we are not able to find any instance of script running. Is there a way to findout whether the... (1 Reply)
Discussion started by: Satyak
1 Replies

7. Shell Programming and Scripting

Need bash script to ping the servers and rename the output file each time the script is ran

HI, I have a file serverlist in that all host names are placed. i have written a small script #./testping #! /bin/bash for i in `cat serverlist` do ping $i >> output.txt done so now it creates a file output.txt till here fine.. now each time i run this script the output file... (4 Replies)
Discussion started by: madhudeva
4 Replies

8. UNIX for Dummies Questions & Answers

Test if script was ran w/ nohup

I want to test if script.sh is being run with nohup ... but $0 does not contain nohup part... purpose: script.sh should only be ran with nohup if user forgets nohup then it should echo "run with nohup" && exit....... (2 Replies)
Discussion started by: holyearth
2 Replies

9. Shell Programming and Scripting

Informatica post session shell script

Hi, This is regarding a issue we are facing in informatica post session. We place a shell script in informatica job. The shell script will need to upload a dummy file to another server.The shell script is running fine.However in informatica job not completing and throwing error It's... (1 Reply)
Discussion started by: nag_sathi
1 Replies

10. Shell Programming and Scripting

Shell script executed from Informatica ETL tool is spawning 2 processes for one script

Hi, I am having a shell script which has a while loop as shown below. while do sleep 60 done I am executing this script from Informatica ETL tool command task from where we can execute UNIX commands/scripts. When i do that, i am seeing 2 processes getting started for one script... (2 Replies)
Discussion started by: chekusi
2 Replies
SLEEP(1)						    BSD General Commands Manual 						  SLEEP(1)

NAME
sleep -- suspend execution for an interval of time SYNOPSIS
sleep seconds DESCRIPTION
The sleep command suspends execution for a minimum of seconds. If the sleep command receives a signal, it takes the standard action. When the SIGINFO signal is received, the estimate of the amount of seconds left to sleep is printed on the standard output. IMPLEMENTATION NOTES
The SIGALRM signal is not handled specially by this implementation. The sleep command allows and honors a non-integer number of seconds to sleep in any form acceptable by strtod(3). This is a non-portable extension, and its use will nearly guarantee that a shell script will not execute properly on another system. EXIT STATUS
The sleep utility exits 0 on success, and >0 if an error occurs. EXAMPLES
To schedule the execution of a command for x number seconds later (with csh(1)): (sleep 1800; sh command_file >& errors)& This incantation would wait a half hour before running the script command_file. (See the at(1) utility.) To reiteratively run a command (with the csh(1)): while (1) if (! -r zzz.rawdata) then sleep 300 else foreach i (`ls *.rawdata`) sleep 70 awk -f collapse_data $i >> results end break endif end The scenario for a script such as this might be: a program currently running is taking longer than expected to process a series of files, and it would be nice to have another program start processing the files created by the first program as soon as it is finished (when zzz.rawdata is created). The script checks every five minutes for the file zzz.rawdata, when the file is found, then another portion processing is done courteously by sleeping for 70 seconds in between each awk job. SEE ALSO
nanosleep(2), sleep(3) STANDARDS
The sleep command is expected to be IEEE Std 1003.2 (``POSIX.2'') compatible. HISTORY
A sleep command appeared in Version 4 AT&T UNIX. BSD
April 18, 1994 BSD
All times are GMT -4. The time now is 12:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy