Find the answer to your Linux question:
Results 1 to 1 of 1
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jul 2010
    Posts
    16

    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.

    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •