Answer Posted / 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..

What is the different type of jobs in datastage?

1030

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3292

---

Is possible to create skid in dim,fact tables?

2692

---

Differentiate between hash file and sequential file?

1129

---

CHANGE CAPTURE

1353

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3693

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1581

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1060

---

How do you generate sequence number in datastage?

1140

---

Explain connectivity between datastage with datasources?

1041

---

What is the difference between in process and inter process?

1203

---

Describe the main features of datastage?

1125

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

969

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

823

---

What is quality stage?

1044

---