Answer Posted / shar

small correction in answer at
sv1<>sv3 then col1 else col1:' ':sv2 --> sv2
and every thing is correct.

What is the sortmerge collector?

1132

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1231

---

How can we improve performance of data stage jobs?

1017

---

What are the different layers in the information server architecture?

1128

---

Define project in datastage?

1101

---

Which algorithm you used for your hashfile?

1186

---

Is it possible to query a hash file?

2012

---

Differentiate between operational datastage (ods) and data warehouse?

1180

---

What is job control?

1119

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085

---

Define Data Stage?

1097

---

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 is ds designer?

1107

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2905

---

What are the types of containers?

1237

---