Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 are the third party tools you used in your project?

1 Answers   IBM,

What is the difference between passive stage and active stage?

0 Answers  

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

what is the difference between == and eq in UNIX shell scripting?

0 Answers   CTS,

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

What are the benefits of datastage?

0 Answers  

what is the use of invokation id

2 Answers   IBM,

What are transforms and what is the differenece between routines and transforms?

0 Answers  

what is usage of datastage with materialized views

4 Answers   HP, TCS,

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 purpose of interprocessor stage in server jobs?

0 Answers   ASD Lab,

For more Data Stage Interview Questions Click Here
Categories