UNIX help with informatica Post: 302822867

Sponsored Content

Special Forums UNIX and Linux Applications UNIX help with informatica Post 302822867 by aliva Dash on Tuesday 18th of June 2013 10:02:35 AM

06-18-2013

Registered User

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 complete the load.
Now i want to add an additional case :
When the source team sends the file to the server after they receive this mail ,the job shall be triggered automatically.
I have n number of informatica jobs and i cannot specify one just workflow name.

My thoughts:
The script which generate mail , it shall sleep for around 2 hrs and then go to the path where the feed is recieved in the server and check for the files.For example:
the mail contain A file and i got A file in the server. It compares both file and return yes.
Now it will pick the concerned job log from the log path and by pmcmd trigger that job.

Will it be feasible?

Thanks

aliva Dash

View Public Profile for aliva Dash

Find all posts by aliva Dash

9 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

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

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

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

4. 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? :)

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

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

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

8. UNIX for Advanced & Expert Users

Teradata and Informatica Load constraints

HI Team , I have interesting issue observed when using teradata sql assistant(14.1) and Informatica tool (9.5) versions. I created SQL code in teradata where source count is 5000 records . I am using source and target database as teradata and trying to load using informatica tool . Its straight...

9. 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.?

LEARN ABOUT DEBIAN

qmove

qmove(1B)								PBS								 qmove(1B)

NAME

       qmove - move pbs batch job

SYNOPSIS

       qmove destination job_identifier ...

DESCRIPTION

       To move a job is to remove the job from the queue in which it resides and instantiate the job in another queue.	The qmove command issues a
       Move Job batch request to the batch server that currently owns each job specified by job_identifier.

       A job in the Running , Transiting , or Exiting state cannot be moved.

OPERANDS

       The first operand is the new destinationfor
	   queue
	   @server
	   queue@server
       See the PBS ERS section , "Destination Identifiers".

       If the destination operand describes only a queue, then qmove will move jobs into the queue of the specified  name  at  the  job's  current
       server.

       If the destination operand describes only a batch server, then qmove will move jobs into the default queue at that batch server.

       If  the destination operand describes both a queue and a batch server, then qmove will move the jobs into the specified queue at the speci-
       fied server.

       All following operands are job_identifiers which specify the jobs to be moved to the new destination.  The qmove  command  accepts  one	or
       more job_identifier operands of the form:
	   sequence_number[.server_name][@server]

STANDARD ERROR

       The qmove command will write a diagnostic messages to standard error for each error occurrence.

EXIT STATUS

       Upon successful processing of all the operands presented to the qmove command, the exit status will be a value of zero.

       If the qmove command fails to process any operand, the command exits with a value greater than zero.

SEE ALSO

       qsub(1B), pbs_movejob(3B)

Local																	 qmove(1B)