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

0 Answers  

---

how to handle null values in sequential file?

1 Answers   HCL,

---

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

---

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---

Wat is pre-load in Hashed file

1 Answers   Patni,

---

Differentiate between validated and Compiled in the Datastage?

0 Answers  

---

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

0 Answers   CTS,

---

How a source file is populated?

0 Answers  

---

Can you highlight the main features of ibm infosphere information server?

0 Answers  

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

how to load meta data

2 Answers   IBM,

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---