Interested to Buy Any Domain ? << Click Here >> for more details...
what is Audit table?Have u use audit table in ur project?
- 3 Answers
- 23602 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
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 |
How a routine is called in datastage job?
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
What is the difference between odbc and drs stage?
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
What is job control?
If the job aborted in a sequencer, how can we start that from the previews successful job.
What are the job parameters?
what is the difference between the active datawarehouse and datawarehouse
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
if ename='subbu' while running job the job should be abort how come?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
Teradata 
