Answer Posted / niraj pathak

Using convert function
Sv1=convert (0123456789,col1,"")

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1342

---

How do you remove duplicate values in datastage?

1105

---

What are the different common services in datastage?

1220

---

Define Data Stage?

1046

---

What is the sortmerge collector?

1090

---

Define APT_CONFIG in Datastage?

1029

---

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

3706

---

Explain ibm infosphere information server and highlight its main features?

1047

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

876

---

What is process model?

1930

---

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

2333

---

Differentiate between Join, Merge and Lookup stage?

1046

---

What is the importance of the exception activity in datastage?

1023

---

What are the types of jobs we have in datastage?

1032

---

Does datastage support slowly changing dimensions ?

1063

---