what is Audit table?Have u use audit table in ur project?
- 3 Answers
- 21947 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhash
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 |
Post New Answer View All Answers
What is the difference between account and directory options ?
Define repository tables in datastage?
How can one find bugs in job sequence?
How a source file is populated?
How one source columns or rows to be loaded in to two different tables?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the enhancements made in datastage 7.5 compare with 7.0?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Why we use surrogate key?
table actions available in oracle connector?
Name the different sorting methods in datastage.
How to perform incremental load in datastage?
What are the various kinds of containers available in datastage?
How can you write parallel routines in datastage PX?
