difference between join and union in reportstudio?
Answers were Sorted based on User's Feedback
Answer / palzkumar
UNION is one of the set operator, which is to apply one or more queries, that results in a projection list on which other queries can be based.
JOIN is not a set operator, but it's used to joins two queries with various relationship's cardinality.
| Is This Answer Correct ? | 1 Yes | 0 No |
IN REPORT STUDIO JOIN IS USED TO JOIN TWO TABLES AND
UNION IS USED TO JOIN 2 REPORTS OR QUERIES.
SHARATH
| Is This Answer Correct ? | 9 Yes | 9 No |
2. What is With Clause In Cognos?
how to improve performance in report studio level
hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...
What are the roles defined by cognos platform?
Can you define metrics designer?
What is catalog and types of catalogs in cagonos and which is better?
What are the components used in web tier?
in which scenario we go for views in cognos or oracle?
what is the difference between aggregation and roll up aggregation?
---------------Tell me about DWH Concepts?
How can we do the unit testing?
what is mean by complex starschema ,star schemagrouping?