Answer Posted / srinu

select translate('1,101;1,102;1,103','1,101;1,102;1,103',1
101,102,103) from dual;

What is the purpose of interprocessor stage in server jobs?

2198

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1169

---

What are the various kinds of containers available in datastage?

997

---

root tree will find which is server job and which is parallel job?

1907

---

How we can covert server job to a parallel job?

1092

---

What is difference between server jobs & parallel jobs?

1007

---

What is the purpose of pivot stage?

1120

---

Define repository tables in datastage?

1124

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2579

---

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

1194

---

What is the method of removing duplicates, without the remove duplicate stage?

985

---

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.

2860

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4159

---

How many types of hash files are there?

1147

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2948

---