Answer Posted / mcssrinivas009

we can use random partion concept

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)

914

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2266

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1536

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3106

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1400

---

Can you define merge?

1105

---

What is the difference between datastage and informatica?

1101

---

what is the difference between == and eq in UNIX shell scripting?

1483

---

How many types of views are there in a datastage director?

1273

---

What are the primary usages of datastage tool?

1064

---

what is ds administrator used for?

1156

---

How do you reject records in a transformer?

1109

---

Can you explain players in datastage?

1179

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2433

---

Does datastage support slowly changing dimensions ?

1099

---