Interested to Buy Any Domain ? << Click Here >> for more details...
difference between join and union in reportstudio?
- 2 Answers
- 14620 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 |
What is Lookup ,bridgeing tables where they will use in the Dataware house
What is snapshot ?
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?
Define dimensions?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
what is stitch query in reportnet?
Can you define cube?
how to convert crosstab into list?
-----------------What is Direct and Conventional loading?
Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....
Teradata 
