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

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

0 Answers   UHG,

What are the steps needed to create a simple basic datastage job?

0 Answers  

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,




how to handle null values in sequential file?

1 Answers   HCL,

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

How do you get log info into a file?

1 Answers  

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

What is a merge in datastage?

0 Answers  

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

For more Data Stage Interview Questions Click Here
Categories