difference between join and union in reportstudio?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you define a catalog and types of catalogs in cognos?

766


What are the themes in a data warehouse?

766


what is online view?

1711


------------ Diff b/w MemberCaption and MemberDescription?

2089


------------------What is Inline Query?

1973


Can you define cube?

773


where you can save the report net documentation in our local system?

825


Why cognos scenario is used?

774


i have one file i saved in csv how can i take these file into framework manager

1766


how you create security to reports?

789


3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2328


What is a Cube?

873


What are the components used in web tier?

722


hi friends pls forward impropmtu interview question

1884


how can you get the errors in job? when loops are araised we get error?

1869