Linux script to check the informatica log

[maya_pillai]

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.

One sample informatica log is attached. The part of the log,linux script needs to look into look like this -(vary for different atble names)

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 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 log and exit.

I have written the attached script. The 'grep' is not working properly. I am sure there can be a better tuned script to handle this.

Can somebody please have a look?

Thanks
Maya