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

What is the roundrobin collector?

1100

---

Notification Activity

1415

---

sed,awk,head

1468

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2369

---

What is a ds designer?

1070

---

How do you run datastage job from the command line?

1094

---

How can we improve performance of data stage jobs?

1019

---

What are the steps required to kill the job in Datastage?

1218

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2376

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2498

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1384

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3759

---

What are stage variables, derivations and constants?

1232

---

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

1090

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2066

---