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 |
can explain wt is the pool for file.
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
How a source file is populated?
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
What is the different type of jobs in datastage?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
Pls tell me what is troubleshooting in datastage view?
why do u need the IOS upgradation in a FC switch
what is time dimension? and how to populate time demension
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me