07-12-2013
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 script to access the database for those source systems. some logic to check counts/etc
and do certain checks based on which scheduling can be planned .
Also there are no source columns related to runday date for particular runs to identify latest data .
For ex: On july 12 --source should have 11th july data .
Please suggest some ideas if any perl or unix script be used
thanks
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello
say i have written some perl scripts , now i like to call them in my unix shell
as unix command like "more" , "ls" , "grep" so that my say perl script called "foo.pl"
will be called from every where as "foo" or "foo arg1 arg2"?
Thanks (1 Reply)
Discussion started by: umen
1 Replies
2. Shell Programming and Scripting
Hi
I am not sure how to call a perl script from a tcsh shell. do i need to set any environment variables? your help is appreciated
Thanks (1 Reply)
Discussion started by: megastar
1 Replies
3. 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
4. Shell Programming and Scripting
hi,,
i have perl scipt with line :
system('./try.sh $t $d $m');
in shell scipt try.sh i have the line:
echo $1
its not printing value of $t that i hav passed..y is it so..i am running it from apache web server (2 Replies)
Discussion started by: raksha.s
2 Replies
5. Shell Programming and Scripting
I am working on this script, but hit a bump. Looking for a little help figuring out the last part:
open(MY_FILE, $ARGV) or die
$COUNTER = 1;
$LINE = <FILE>;
while ($LINE, <FILE>) {
# Adds leading zeros for numbers 1 digit long
if ($COUNTER<10){
print "000";
}
# Adds... (2 Replies)
Discussion started by: Breakology
2 Replies
6. Shell Programming and Scripting
Hi
I m new to perl. I m trying to write a perl script that calls a bash script; does anyone have a script already that they can provide or help me out? Thanks a lot. (2 Replies)
Discussion started by: adnan786
2 Replies
7. 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
8. Shell Programming and Scripting
Hello Gurus
Can anyone please let me know how to call .profle file in perl script
When I am calling the .profile file its giving error
Shall I create unix script which has .profile command and call perl script internally (2 Replies)
Discussion started by: Pratik4891
2 Replies
9. Shell Programming and Scripting
I'm attempting to write a bash script that will create a network between virtual machines. It accepts three arguments: an RSpec that describes the network topology, and two list of machines (servers and clients).
I have a (working) Perl script that I want to call. This Perl script takes an RSpec... (6 Replies)
Discussion started by: mecaka
6 Replies
10. Shell Programming and Scripting
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
LEARN ABOUT REDHAT
xtremoveinput
XtAppAddInput(3Xt) XT FUNCTIONS XtAppAddInput(3Xt)
NAME
XtAppAddInput, XtRemoveInput - register and remove an input source
SYNTAX
XtInputId XtAppAddInput(app_context, source, condition, proc, client_data)
XtAppContext app_context;
int source;
XtPointer condition;
XtInputCallbackProc proc;
XtPointer client_data;
void XtRemoveInput(id)
XtInputId id;
ARGUMENTS
app_context
Specifies the application context that identifies the application.
client_data
Specifies the argument that is to be passed to the specified procedure when input is available.
condition Specifies the mask that indicates a read, write, or exception condition or some operating system dependent condition.
id Specifies the ID returned from the corresponding XtAppAddInput call.
proc Specifies the procedure that is to be called when input is available.
source Specifies the source file descriptor on a UNIX-based system or other operating system dependent device specification.
DESCRIPTION
The XtAppAddInput function registers with the Intrinsics read routine a new source of events, which is usually file input but can also be
file output. Note that file should be loosely interpreted to mean any sink or source of data. XtAppAddInput also specifies the conditions
under which the source can generate events. When input is pending on this source, the callback procedure is called.
The legal values for the condition argument are operating-system dependent. On a UNIX-based system, the condition is some union of XtInpu-
tReadMask, XtInputWriteMask, and XtInputExceptMask. The XtRemoveInput function causes the Intrinsics read routine to stop watching for
input from the input source.
SEE ALSO
XtAppAddTimeOut(3Xt),XtAppAddSignal(3Xt)
X Toolkit Intrinsics - C Language Interface
Xlib - C Language X Interface
BUGS
In ANSI C it is necessary to cast the condition to an XtPointer, e.g.:
XtAppAddInput(app_context,
source,
(XtPointer) (XtInputReadMask | XtInputWriteMask),
proc,
client_data);
X Version 11 Release 6.6 XtAppAddInput(3Xt)