08-05-2010
Linux script to check the informatica log
Hi,
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]
MAPPING> TM_6253 Target Load Summary.
MAPPING> CMN_1740 Table: [W_CASE_F] (Instance Name: [W_CASE_F])
Output Rows [1], Affected Rows [1], Applied Rows [1], Rejected Rows [0]
--------------------
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
3. 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.
Can somebody please help?
Thanks
Maya
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I am not sure whether this is the right place to ask this question...:)
I am working in Informatica PowerCenter 8.1.1 tool and my server is on UNIX. I have got a shell script to copy files from one folder to another.
When I run the script directly from UNIX prompt it is taking 60... (0 Replies)
Discussion started by: sam99
0 Replies
2. Shell Programming and Scripting
We have almost 100+ Unix/Linux servers, on which I have account.
Does anybody have a batch script which can do the following :
- check if my password is correct
- change my password
We use SFTP/SSH on Linux. The solution should force reading of password from command line. ( Passwordless... (1 Reply)
Discussion started by: lucknowm
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
Request Any one of your to provide me a script which does the following in a single unix script.
Basically Users will load data in SHARED LINK everyday, should write a UNIX SCRIPT which will ........
1) Unix script should Open the LINK (FTP)
2) Each DIRECTORY in the link contains many... (0 Replies)
Discussion started by: informaticalabs
0 Replies
5. 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
6. Shell Programming and Scripting
I need a bash script to check connected/disconnected usb with linux.
I know command lsusb can be use to list down usb connect with linux. output of lsusb command is like this:
Bus 001 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
Bus 001 Device 002: ID 0951:1643 Kingston... (1 Reply)
Discussion started by: kashif.live
1 Replies
7. Shell Programming and Scripting
Hi,
Script to check the ETL standards in an informatica mapping ( xml file ).
Example:
To check the naming standard of mapping .
To check the transformation naming convention.
To check the datatypes.
To the session name , it should start with s.
To check the workflow name , it should... (0 Replies)
Discussion started by: srimadhuri
0 Replies
8. Shell Programming and Scripting
Hi,
This is regarding a issue we are facing in informatica post session. We place a shell script in informatica job.
The shell script will need to upload a dummy file to another server.The shell script is running fine.However in informatica job not completing and throwing error
It's... (1 Reply)
Discussion started by: nag_sathi
1 Replies
9. Shell Programming and Scripting
Hi,
I am having a shell script which has a while loop as shown below.
while
do
sleep 60
done
I am executing this script from Informatica ETL tool command task from where we can execute UNIX commands/scripts. When i do that, i am seeing 2 processes getting started for one script... (2 Replies)
Discussion started by: chekusi
2 Replies
10. Shell Programming and Scripting
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
LEARN ABOUT NETBSD
rcsfreeze
RCSFREEZE(1) General Commands Manual RCSFREEZE(1)
NAME
rcsfreeze - freeze a configuration of sources checked in under RCS
SYNOPSIS
rcsfreeze [name]
DESCRIPTION
rcsfreeze assigns a symbolic revision number to a set of RCS files that form a valid configuration.
The idea is to run rcsfreeze each time a new version is checked in. A unique symbolic name (C_number, where number is increased each time
rcsfreeze is run) is then assigned to the most recent revision of each RCS file of the main trunk.
An optional name argument to rcsfreeze gives a symbolic name to the configuration. The unique identifier is still generated and is listed
in the log file but it will not appear as part of the symbolic revision name in the actual RCS files.
A log message is requested from the user for future reference.
The shell script works only on all RCS files at one time. All changed files must be checked in already. Run rcsclean(1) first and see
whether any sources remain in the current directory.
FILES
RCS/.rcsfreeze.ver
version number
RCS/.rcsfreeze.log
log messages, most recent first
AUTHOR
Stephan v. Bechtolsheim
SEE ALSO
co(1), rcs(1), rcsclean(1), rlog(1)
BUGS
rcsfreeze does not check whether any sources are checked out and modified.
Although both source file names and RCS file names are accepted, they are not paired as usual with RCS commands.
Error checking is rudimentary.
rcsfreeze is just an optional example shell script, and should not be taken too seriously. See CVS for a more complete solution.
GNU RCSFREEZE(1)