Answer / the_xxx

The main difference between UNION ALL and UNION is UNION
only selects distinct values, UNION ALL selects all values
(including duplicates).

Answer / abd hfz

UNION gives result set of only distinct values from both
tables where as UNION ALL selects all values including
duplicates.

Answer / sridevi

UNION will give only distinct values where as UNION ALL gives all the values including duplicates.Performance wise UNION ALL is faster than UNION because UNION needs to exclude duplicates.

6. Which of them will increase the performance?

1 Answers  

---

How can we convert imr report into Impromptu web report?

3 Answers  

---

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

1 Answers  

---

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

1 Answers  

---

1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?

2 Answers   Cognizant,

---

A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?

1 Answers  

---

How to create a cube in Transformer? What is the process? Please mention process thank u

1 Answers   Genpact,

---

Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480

7 Answers  

---

------------------- What is Busschema?

1 Answers   Cap Gemini,

---

----------------------Diff b/w MOLAP and ROLAP?

4 Answers   Bank Of America,

---

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1 Answers  

---

suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

2 Answers   Mind Tree,

---