Interested to Buy Any Domain ? << Click Here >> for more details...
difference between join and union in reportstudio?
- 2 Answers
- 14665 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 |
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
Can you define metrics designer?
What are the different type of securities can we apply in framework manager?
How you drill from powerPLay to Impromptu?Explain all Steps?
-------------How you design DWH?
Create 12 columns for months by writing single case statement?
Is it possible to join multiple Databases in a Catalog?
what is view? types of views?
what is the use of macros&folders&herarchies in frameworkmanger?
------------ Diff b/w MemberCaption and MemberDescription?
WHAT ARE THE DISTNICT VARIABLES?
i have a table with 3 columns country,empname,salary and i want the query for get the name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance
Teradata 
