Answer / kiran

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

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

Answer / shalini shanmugam

Audit Tables are used to track selected user database transactions.
audit tables are filled through database triggers.

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 i don't need "_"ex nnnxx this type i want

3 Answers  

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

0 Answers   TCS,

---

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,

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

specify data stage strength?

1 Answers  

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---

How to clean the datastage repository?

0 Answers  

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

Differentiate between Join, Merge and Lookup stage?

0 Answers  

---

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

---

What is a datastage job?

0 Answers  

---

What is oci?

0 Answers  

---