what is Audit table?Have u use audit table in ur project?
Answers were Sorted based on User's Feedback
Answer / kiran
Audit table mean its log file.in every job should has audit
table.
| Is This Answer Correct ? | 25 Yes | 5 No |
Audit table can be used to check all the details of the
jobs like :
Job status, Last run date
number of rows processed
number os rows entered / rejected in a job,
some companies use shell script to load logs into audit
table & some companies load logs into audit table using
datastage jobs.
Ex:
JOB_DETAIL table, It may contain columns like:
JOB_ID, JOB_NAME, STATUS, JOB_RUN_DT, REC_INSERTED,
REC_UPDATED etc..
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / shalini shanmugam
Audit Tables are used to track selected user database transactions.
audit tables are filled through database triggers.
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the processing stages?
What is the difference between datastage and datastage tx?
How do you generate sequence number in datastage?
How to initialize environment variables?
What is ibm datastage flow designer?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
Name the third party tools that can be used in datastage?
What is "fatal error/rdbms code 3996" error?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
When we will go for Data elements?
can we use sequential file as a lookup