Skip to Content
author's profile photo Former Member
Former Member

Auditing Feature- encountering wierd issue

Hi

i have a job where i am joing two tables, applying some filters and loading into a target.

When i apply Auditing feature on the source, i am not able to load data into the Target. But once i remove the audit, It loads successfully.

Please help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2014 at 02:05 PM

    Hi,

    Is audit capturing exceptions?

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Arun

      i am attaching the flow and monitor log for the job with and without auditing.

      With auditing, i am getting 228339 records in BODS but nothing is loaded into target but without auditing 74380 records are extracted into BODS and same is loaded into target.

      Flow is exactly same. only difference is of Auditing.

      74380 is the correct no of records which should be loaded to Target.

      See if you can help

      With_Auditing

      Flow

      Without_Auditing

      flow.PNG (9.7 kB)
      With_Audit.png (22.6 kB)
      Without Audit.png (22.3 kB)
  • Posted on Jan 22, 2014 at 08:35 AM

    Hi Suraj,

    May be its funny, but can you please check once again your Audit condition applied.

    Please try and update the thread

    Shiva Sahu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.