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 |
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How can we achive parallelism
how to unlock a locked job in datastage 8.0
whats difference between ls -ltr and ls -lrt?
Wat is pre-load in Hashed file
What are the different kinds of views available in a datastage director?
What are routines in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
what is factless fact table?
how can or from where we can get reference data in scd type2 implementation?
How can we improve the performance in datastage?
How can u write exception handling in seq file????