Interested to Buy Any Domain ? << Click Here >> for more details...
difference between join and union in reportstudio?
- 2 Answers
- 14737 Views
- IBM, I also Faced
- E-Mail Answers
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 |
I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?
In which types of reports does the page breaks applicable in Cognos...?
Can we create a web page where the report directory and the output can be viewed directly across cognos connection?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
Define cognos report net?
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
what is a join? what are the types of joins?
how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?
Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.
what r the filters in fwm and report studio
Teradata 
