UNIX help with informatica

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications UNIX help with informatica
# 1  
Old 06-18-2013
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
# 2  
Old 06-19-2013
You could poll for zero byte files in target areas, assuming the 3 hours does not bother you, and email out any additions to the list, perhaps a 15 minute cron or loop. Is this checking an extract or a file move?
# 3  
Old 09-18-2013
informatica

Thanks for providing the best information it's very useful for Informatica learners.123trainings also provide the best<a href="http://123trainings.com/it-informatica-online-training.html">Informatica Online Training</a> you can see free demo <a href="http://www.youtube.com/watch?v=CGSHXwpfbo0">Informatica Online Training Demo in Hyderabad India</a>
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 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... (0 Replies)
Discussion started by: Perlbaby
0 Replies

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

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

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... (0 Replies)
Discussion started by: gurukrishnan
0 Replies

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

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

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

9. 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=... (0 Replies)
Discussion started by: fgene1
0 Replies
Login or Register to Ask a Question