We do run the ETL jobs via DataStage.
We do have 30 sequences which calls 1 update query.
Most of the time when the update query is run by many countries, the ETL job gets hang.
Becuase of this we have written a above script.
We do in the script i.,e if any job is running for a particular country, the next job will wait to finish the previous one.
Some cases like FVL, gfl, scf the script works fine.
but some cases like eas, bog, cld the scripts runs all the etl job at same time.
Here instance_Name is fvl, gfl, scf, eas, bog, cld.
Any modification/suggestion would be appreciated.
thank you
Moderator's Comments:
Please take time to spell correctly, use code tags and do not double post.
Location: Asia Pacific, Cyberspace, in the Dark Dystopia
Posts: 19,118
Thanks Given: 2,351
Thanked 3,359 Times in 1,878 Posts
In order to get a quality reply, you should provide both sample input and output data.
---------- Post updated at 07:17 ---------- Previous update was at 07:08 ----------
In addition, posters should not cut-and-paste their problems in multiple internet forums, requesting solutions, all within the same day or few hours.
This same question was posted in the HPRC forums with the same subject (as the one closed earlier for double posting) "Subject: Unix Script" at Oct 26, 2010 15:09:02 GMT here.
Moderator's Comments:
I am closing this thread because the poster has posted in another forum, double posted the same question in these forums, and does not follow posting guidelines on formatting, code tags, descriptive subject text, etc.
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)
Hi,
Script to check the ETL standards in an informatica mapping ( xml file ).
Example:
To check the naming standard of mapping .
To check the transformation naming convention.
To check the datatypes.
To the session name , it should start with s.
To check the workflow name , it should... (0 Replies)
Hi, I am new to this subject.....Can someone please help me out with the script...
unix usernm "sdhftst"
unix pwd "chsd13"
windows usernm "dfghtst"
windows pwd "chsd13"
path..../xxx/xxxxx/xxxxxx/xxxxxxx
please can u get me a script...its only one file to get ftp.
Thanks... (2 Replies)
Hello
I am very new to Unix scripting,
I am using informatica etl,which is schedule by tidal enterprise.
I have a scenario where assume that Tidal only knows how to run jobs at a given time and does not know how to retry.
So i want to know weather can i write a shell script such that... (1 Reply)
Hi Gurus,
I want to perform following task :
I am getting new text file every month in CD format.
Now by using 3rd party ETL tool which is installed in UNIX I want to run the job whose input file will be this file from CD. So I need to FTP text file from my client machine CD drive to UNIX.... (2 Replies)
Hi,
My local server is :/usr/abcd/
Remote server is :/Usr/host/test/
I want to send files from local unix directory(All files starting with O_999) to
remote host unix directory.
Can any body give me the Unix Shell script to do this.
One more doubt: Shall we need to change the file... (1 Reply)