Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / narsi

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

How to RD using transformer?

0 Answers   CTS,

What is Fastly Changing Dimension?

6 Answers   TCS,

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,

How to add zero "0" before record in a field?

4 Answers  

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

how to create document in datastage?

1 Answers   Cap Gemini,

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,

Can you explain engine tier in information server?

0 Answers  

which unix commands mostly used in datastage

3 Answers   HSBC,

How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,

What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories