what is Audit table?Have u use audit table in ur project?
- 3 Answers
- 22334 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 |
Explain the ChangeApply stage?
Tell me Wt main advantage of Stage varibles? Project level hints?
Differentiate between datastage and informatica?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
How did you reconcile source with target?
how to define satge variables in transformer stage
in aggregator , how can i get the sum in readable format
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Define Job control?
Pls tell me what is troubleshooting in datastage view?
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
Teradata 
