Interested to Buy Any Domain ? << Click Here >> for more details...
what is Audit table?Have u use audit table in ur project?
- 3 Answers
- 23432 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
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 |
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
How to convert RGB Value to Hexadecimal values in datastage?
How many types of sorting methods are available in datastage?
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
How to create environments and call them? What is the use defined variables?
What are the main features of datastage?
how many dimentions and fact tables used in your project and what are names of it?
What are data elements?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
how to load meta data
Teradata 
