-------------Diff b/w Union and Unionall?
Answer Posted / 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.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of powerplay web viewer in cognos?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What are the steps to import the two data sources in framework manager?
------------------What is Inline Query?
What are various types of gateways in cognos?
Why need staging area database for dwh?
i was asked what are the caluclations done by you in your report? plz give reply
WHAT ARE THE DISTNICT VARIABLES?
Write types of folders present in cognos?
Mention the difference between ‘macros’ and ‘prompt’?
how to merge 2 crosstabs thans
Tell me about Dnamic and Static Dashboards?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.