Answer Posted / prasad

take one stage variable

sV: if (IsNull(colum_name) or Column_name='') Then 0 Else 1

and in constraint use
sV=0 (null records will goes to one target)(we can handle null by using stage variable)

sV=1 (not null records will goes to another target)

Plz Correct me, if am wrong......

Differentiate between validated and Compiled in the Datastage?

1268

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2470

---

What is apt_config in datastage?

1131

---

What are the steps needed to create a simple basic datastage job?

1228

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2247

---

What are the repository tables in datastage?

1301

---

Define Merge?

1312

---

What are iconv and oconv?

1237

---

How many areas for files does datastage have?

1146

---

whom do you report?

1921

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2100

---

What is quality stage?

983

---

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

1162

---

how to write server Routine coding?

2115

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2499

---