Programming :: Script To Check The Informatica Log?

Aug 4, 2010

We are loading 100 + oracle tables using informatica. At the end of the run, we need to verify the informatica log to confirm the rows are loaded properly to target tables. There are so many detials included in the etllog. But,the part of the informatica log, linux script needs to look into look like as below -(vary for different table names. here, CMN_1740 is the table name.)

MAPPING> TM_6252 Source Load Summary.
MAPPING> CMN_1740 Table: [SQ_W_CASE_FS] (Instance Name: [SQ_W_CASE_FS])
Output Rows [1], Affected Rows [1], Applied Rows [1], Rejected Rows [0]

[code]....

1. The details of source load summary (source table name and the details -Output Rows [1], Affected Rows [1], Applied Rows [1], Rejected Rows [0]) should be written to a log. We need to check whether the affected rows is 0 or rejected rows > 0 for source load summary. In that case , script should write that to a log and exit

2. The details of target load summary (target table name and the details -Output Rows [1], Affected Rows [1], Applied Rows [1], Rejected Rows [0]) should be written to a log

3. We need to check whether the affected rows is 0 or rejected rows > 0 for target load summary. In that case, script should write that to a log and exit.

4.The above steps should be repeated for all set of tables mentioned in the etllog.

View 2 Replies


ADVERTISEMENT

Software :: Install Informatica On System Guide?

May 30, 2010

Do we have informatica for download anywhere?
The current version of Informatica happens to be 8.6
Please, provide me the details.
And, also how to install informatica on linux guide?

View 5 Replies View Related

Programming :: Check Menu & Check List In Utility Dialog?

Aug 19, 2010

I want to put check menu & check list in utility dialog.i dont know how i do this

View 1 Replies View Related

Programming :: Check If There Is Such A Value In The Database

Feb 10, 2010

sql statement. I am trying to check if there is such a value in the database.

Code:
string NewMovie = "ww";
string queryText ;
queryText = "Select * from movie_info WHERE movie_title = '"+ NewTitle +"'";
MYSQL *conn;
conn=mysql_init(NULL);
mysql_real_connect(conn,host,username,password,database,0,NULL,0);
[Code]......

return 0; The problem i am facing is how do i check if the value is found. I read up and found that a query will return a value of TRUE if the query is a success and a FAIL if there is an error. How do i call these values and then based the check on it?

View 1 Replies View Related

Programming :: How To Check The Environment

Jul 22, 2011

I have written a tiny script for kernel compilation, which call menuconfig and then compile the kernel. It is working fine. Now I like to test my environment and if it is shell menuconfig will be called and if X then xconfig will be called. How can I check the environment then?

View 7 Replies View Related

Programming :: Check If $var Is Not Start With 0

May 25, 2010

I need to check if $var is not start with 0

Code:
read var
if [ $var IS NOT START WITH 0 (or something like 006077) ];then echo 'Good'

View 15 Replies View Related

Programming :: Check If Any Directories Exist, Except A Certain One?

Aug 5, 2010

I need to find if, in a folder any directories exist, except a certain one named "mes croquis".What I am trying to say, is that the re already is a directory named "my croquis", which I have to ignore. IF any other directory appears, I have to archive them.I got everything so far, except the starting condition.In other terms , I am lookign for something like this:

IF anyDir EXIST AND name != "mes croquis"
do something
else

[code]....

View 2 Replies View Related

Programming :: Check If The Variable Is A Number Or Not

Apr 30, 2011

I've created (as a homework) to create as many folders as told but I still need to check if the variable is a number or not :

Code: #!/bin/sh
echo "Veuillez saisir un nombre"; read nmbr
nmbrf=$nmbr
while [ $nmbrf -gt 0 ]
do mkdir -p "foo$nmbrf"
nmbrf=`expr $nmbrf - 1`
echo "$nmbrf"

how do I check that nmbr is a number or something else?

View 1 Replies View Related

Programming :: Check Whether The First Character Is TAB Or Space?

May 11, 2011

I have a file with one line. I want to check whether the first character is TAB or space, how can i do this.? using "cut" wont as it "bypasses the tab and space characters"

View 3 Replies View Related

Programming :: Check The Db For Some Value And Run Some Functions To Do Some Checks?

May 15, 2011

have an application where from time to time I need to check the db for some value and run some functions to do some checks. is the best option do it as php daemon or cron job?Whatworried of cron job is the overalapping.

View 9 Replies View Related

Programming :: Check If Log File Is A Certain Size?

Mar 25, 2010

script that will check if my log file is a certain size? EX: I want to limit the size of my rsync log to say 5MB, if that's true I would move it and create a new one.

View 4 Replies View Related

Programming :: C++ Check If Pointer Is Deleted?

Apr 24, 2011

Is it possible to check if a pointer is deleted in C++ (using GDB)? For example:

Code:
a = new Thing();
b = a;
delete a;

// If all I have is the variable "b", how can I tell if it was deleted?

View 14 Replies View Related

Programming :: Check Server Load Via Php?

Mar 4, 2011

We have 7 webservers running in a cluster, and I have zenoss running which does monitor space, network, even performance, but I would like a nice small webpage that I could break into just a few rows of a table. I would like to be able to simple do a reload every 30/60 seconds, and just have the following;row1: server load, memory userow2: server load, memory useBefore the row, if the load > x change the css to make it red (so I could notice it), etc. The css, the refresh, etc. is all simple, I am jut wondering how I could go about getting the load and memory use from PHP.I could setup a bash script that could get the info and spit it to a file as a last resort, but curious if there was a more direct way.

View 3 Replies View Related

Programming :: Check Available Space On A Directory With C++?

Sep 23, 2010

i'm using c++ and Ubuntu and I need to write/copy some files to a directory chosen by the user of my system (the user can save it on any folder of any disk of the pc or other usb device). Before I do it, I need to know if there's space available on the disk. I cannot only check the result of write() function, the validation must be executed before I start to save or copy.

I was trying to use statvsf structure, but I only have the complete filepath (/home/lobinho/myDocs/), not the disk path. The statvfs() function only works with disk path (i.e. /media/KINGSTON ).

The source of my function:

Code:
int MyClass::availableSpace(string dst, ulong* availableSize) {
int result = ERROR;
try {
struct statvfs devData;

[Code]...

View 4 Replies View Related

Programming :: How To Check For Empty Variables In PHP

Apr 26, 2010

I want to check if a MySQL db query will return an empty result - I first do this:

$query="SELECT * from <whatever" ;
$result=mysql_query($query) ;
$row=mysql_fetch_row($result) ;

Now how do I check if $row is empty or not? Will $row="" do the trick?

View 2 Replies View Related

Programming :: Check If Buffer Is Empty In C?

Apr 12, 2011

Greetings EveryOne

how to check if buffer is empty in c?

View 14 Replies View Related

Programming :: Check In C App What Has Been It Installation Prefix?

Apr 10, 2010

I'm writing a application which uses translates and I wonder how to check what has been prefix of it's installation to check where translation files are stored. I'm using cmake so maybe is there some preprocessor definition of installation prefix

View 4 Replies View Related

Programming :: Unable To Check / Uncheck Any Box

Apr 12, 2010

I'm messing with a JTree, I need one that has checkboxes to check/uncheck options, and (later) textboxes to edit options....but for now, the checkboxes don't wanna play. Here's the source:

package Habitat.EnvCtrl;
import java.awt.BorderLayout;import MailPopper.hlprs.CheckBoxNode;
import java.awt.Dimension;
import java.util.Vector;
import javax.swing.JDesktopPane;
import javax.swing.JInternalFrame;
import javax.swing.JScrollPane;
import javax.swing.JTree;
import javax.swing.tree.DefaultMutableTreeNode;
import javax.swing.tree.TreeNode; .....

The rtree builds (albeit I have a superfluous extra checkbox in there I don't know where it comes from...) but I cannot check/uncheck any boxes.

View 1 Replies View Related

Programming :: Check Command Line For A Word?

May 23, 2010

I'm building a script for my place of employment. The next step in it is checking what the user input was. Determining if they added a part in there or not. The script prompts for a hostname. Hostnames are localhost.localdomain. Now, I want the script to check to see if they put localdomain and if they did, not to add the domain to the /etc/sysconfig/network, but just what they entered. So say the user inputs:

[Code]....

View 4 Replies View Related

Programming :: Check For Word Frequency In 1 Column

Jul 6, 2010

I have a large tab delimited text file, about 17gb. It only has 6 column. On column number 4, it is all numbers. Ranging from 1-1000. I want to count how many times each number occured. So the output I want is in 2 columns, first one is a number, second column is how many times it occured. I tried

head -n 1000 coverage | cut -f 4 | uniq -c

Didn't work for me, the first column returned is not unique.

View 3 Replies View Related

Programming :: Check If There Is Any Ejb File Exists In The Directory

May 1, 2011

I have a directory called /data In this directory I have some files like abcejb.jar,12_ab_ejb.jar, shejb.jar, test I need a shell script like... 1st I want to check if there is any ejb file exists in the directory using some condition If ejb files exists I want to redirect the ejb files list to a file called list. Now I want to copy all the files in the list file to some remote system.

View 1 Replies View Related

Programming :: BASH - Can't Check If XScreenSaver Is Running

Feb 26, 2011

I'm having trouble trying to make a script. What I want to do is check if xScreenSaver is running in my user account. If not, run it. If it's running, kill it.

So this is the script I've made:

Code:

The problem is that I've echoed the output of $(pgrep -u $(whoami) xscreensaver) and it always seems to add 4 numbers to the pid, even if the pid doesn't exist. What do I mean by "doesn't exist"? That no xscreensaver is running in my user, and if I run pgrep -u $(whoami) xscreensaver in bash, I get not output, but if I run the command though the script, I get (for instance) 4050. If I run it again, I get 4054, and again 4058... etc. What the hell is going on with that?

View 5 Replies View Related

Programming :: Bash Function Check For Valid IP?

Apr 16, 2010

I have been working on this way too long now...this *should* be simple. I must be missing something simple at this point.

Code:
function f_is_ip()
{
if [ "`echo "$1" | /bin/egrep "[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}"`" != "" ] ## Error on this line

[Code]....

When I echo $1 ## prints 192.168.1.22

View 4 Replies View Related

Programming :: C - Check If An Input Char Contain Numbers?

Mar 19, 2010

I would like to create a small C tool. I encounter a problem of how to make a function to check an input chars contains numbers (started from the second element).

Some samples:

char *mychar= "a3547"; (The result of function checking this is true)
char *another_char = "t6548"; (The result of function checking this is true)
char *next_char = "appl3"; (The result of function checking this is false)
char *new_char = "b1aa3"; (The result of function checking this is false)

View 4 Replies View Related

Programming :: C Preprocessor Fails Sanity Check?

Jan 31, 2010

Recently, every time I try to compile an app from its source code, after issuing the ./configure command I get this message:configure: error: C preprocessor "/lib/cpp" fails sanity checkSee `config.log' for more details.I check /lib/cpp but there is not directory named /cpp under /libthis problem occurs on all source packages.

View 3 Replies View Related

Programming :: C Program To Check If Network Connection Available Or Not?

Jun 3, 2011

I am writing a simple C program which has to find whether the system is connected to network/internet or not..

View 10 Replies View Related

Programming :: Check If A Part Of String Exist

Sep 27, 2010

I have a macro which I use with ROOT. In this macro I want to check if a part of string exist so I can ignore it inside a loop. So, inside a loop I want to have something like:

Code:
if (string == "pre_ti_data_bdt*" || string == "pre_ti_data_nn*")
continue;

but of course I cannot use * in this piece of code! How to do this trick in C++?

View 5 Replies View Related

Programming :: Check If An Array Is Empty In Perl?

Nov 28, 2008

To do this, can I do this?:

if (@ary = ""),

or is something more needed?

View 4 Replies View Related

Programming :: Check .xml File And Which Character Is Malformed In 'utf-8'?

Jun 15, 2011

I need some software that will check .xml file and tell me which character is malformed in 'utf-8'. I am using perl for some parsing.

View 2 Replies View Related

Programming :: Setup Array To Check Tables?

Nov 9, 2010

I want to specify about 10 tables that should be checked before the application starts, since if they are empty the results are not so good!

Here is what I have so far:

//specify what tables we want to check
$db_array =
array("attendance_codes","ethnicity","generations","grades","grade_terms","health_codes",$
//walk the array checking each table for more than 0 records

[code]....

it's not working,

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved