top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Auditing Tables in Informatica

+1 vote
537 views

We want to maintain auditing of tables , For that my question is 1)will the commit interval in Informatica will be stored anywhere in any variable , so that we can maintain the record count for every commit interval.

2)is there any method/script to read the stats from session log and save in audit table.

3)If there are multiple targets in my mapping then in monitor after executing it will show target success count and target reject count as total for all the targets in the mapping. how to get individual target success and reject count .

posted Nov 24, 2014 by Sunil

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
0 votes

In informatica i receive dates from flat files in the format of dd-mm-yyyy and dd/mm/yyyy i need to convert all date to one format i.e dd-mm-yyyy using any expression and push into target ,so no rows gets rejected.how to proceed with them?

+2 votes

I want to know how to rename the ODBC data source in informatica.

+1 vote

I want to know how to rename the ODBC data source in informatica.

+2 votes

I am trying to join 6 tables where 5 tables are located in Netezza database and the last table is present in SQL Server database. I need to join these six tables and extract all the required fields and load them into the target table which is located on Netezza.I tried writing SQL in SQL override to join all the tables but it throws me an error. Can someone help me how to resolve this issue?

Thank you.

+1 vote

I am trying to join 6 tables where 5 tables are located in Netezza database and the last table is present in SQL Server database. I need to join these six tables and extract all the required fields and load them into the target table which is located on Netezza.I tried writing SQL in SQL override to join all the tables but it throws me an error. Can someone help me how to resolve this issue?

...