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)

0 Answers  

---

Difference between data warehousing and olap?

0 Answers  

---

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

---

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

How and where you used hash file?

0 Answers  

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

what is factless fact table?

3 Answers   IBM,

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

how to abort the job its matain duplicates?

0 Answers   TCS,

---