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 are the partitioning techniques available in link partitioner?

2251

---

Explain entity, attribute and relationship in datastage?

1064

---

Can you explain link buffering?

1129

---

Describe link sort?

973

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2210

---

Can you define merge?

1079

---

What are some different alternative commands associated with "dsjob"?

1120

---

What are some prerequisites for datastage?

1061

---

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

1492

---

What is the flow of loading data into fact & dimensional tables?

1032

---

Differentiate between operational datastage (ods) and data warehouse?

1140

---

What are the types of containers?

1167

---

How do you register plug-ins?

940

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1028

---

How to convert RGB Value to Hexadecimal values in datastage?

3958

---