what is Audit table?Have u use audit table in ur project?

Answers were Sorted based on User's Feedback



what is Audit table?Have u use audit table in ur project?..

Answer / kiran

Audit table mean its log file.in every job should has audit
table.

Is This Answer Correct ?    25 Yes 5 No

what is Audit table?Have u use audit table in ur project?..

Answer / 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

what is Audit table?Have u use audit table in ur project?..

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

Post New Answer

More Data Stage Interview Questions

can explain wt is the pool for file.

1 Answers   CTS,


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

4 Answers  


How a source file is populated?

1 Answers  


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 Answers   TCS,


1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,


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..

4 Answers   Wipro,


What is the different type of jobs in datastage?

1 Answers  


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?

2 Answers   Wipro,


Pls tell me what is troubleshooting in datastage view?

1 Answers  


why do u need the IOS upgradation in a FC switch

1 Answers   IBM,


what is time dimension? and how to populate time demension

2 Answers   TCS,


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

0 Answers  


Categories