Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: UNIX/Perl script to call informatica source counts
Top Forums Shell Programming and Scripting UNIX/Perl script to call informatica source counts Post 302831925 by Perlbaby on Friday 12th of July 2013 09:31:10 AM
Old 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

how can call perl script as command?

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

how to call a perl script from tcsh?

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

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

4. Shell Programming and Scripting

call shell script from perl cgi script problem

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

Perl script that counts lines of a file

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

how to call a bash script using perl

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

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

8. Shell Programming and Scripting

Call .profile in perl script

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

Call a Perl script within a bash script and store the ouput in a .txt file

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

Using Isql for SQL SERVER to get the table rows counts in UNIX shell script to

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 CENTOS

ibus-table-createdb

IBUS-TABLE-CREATEDB(1)													    IBUS-TABLE-CREATEDB(1)

NAME

       ibus-table-createdb - create ibus-table database from table source

SYNOPSIS

       ibus-table-createdb  [  [ -n name ]  [ --name name ]  ]	[  [ -s source ]  [ --source source ]  ]  [  [ -e extra ]  [ --extra extra ]  ]  [
       [ -p pinyin ]  [ --pinyin pinyin ]  ]  [ -o ]  [ --no-create-index ]  [ -i ]  [ --create-index-only ]  [ -d ]  [ --debug ]

DESCRIPTION

       ibus-table-createdb creates a database for ibus-table from a source table.

OPTIONS

       This program follows the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is  included
       below.

       -n     database-file  specifies	the  file name for the binary database for the IME. The default is ''. If the file name of the database is
	      not specified, the file name of the source file before the first '.' will be appended with '.db' and that will be used as  the  file
	      name of the database.

       -s     source-file specifies the file which contains the source of the IME. The default is ''.

       -e     extra-words-file specifies the file name for the extra words for the IME. The default is ''.

       -p     pinyin-file specifies the source file for the pinyin. The default is '/usr/share/ibus-table/data/pinyin_table.txt.bz2'.

       -o     Do not create an index for a database (Only for distribution purposes, a normal user should not use this flag!)

       -i     Only  create  an	index  for  an	existing database. Specifying the file name of the binary database with the -n or --name option is
	      required when this option is used.

       -d     Print extra debug messages.

EXAMPLES

       ibus-table-createdb -n ipa-x-sampa.db -s ipa-x-sampa.txt
	      Create the binary database ``ipa-x-sampa.db'' from the source file ``ipa-x-sampa.txt''.

       ibus-table-createdb -i -n ipa-x-sampa.db
	      Create an index for the database ``ipa-x-sampa.db''.

AUTHOR

       This manual page was written by Mike FABIAN <mfabian@redhat.com>.

								   Apr 18, 2013 					    IBUS-TABLE-CREATEDB(1)
All times are GMT -4. The time now is 05:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy