-------------Diff b/w Union and Unionall?
Answer Posted / abd hfz
UNION gives result set of only distinct values from both
tables where as UNION ALL selects all values including
duplicates.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What do you understand by the cognos?
Can you define dimension?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
Can you define query studio?
What are query items?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
Define query studio?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
When we save a report in report studio with what extn it save?
Explain difference between powerplay transformer and power play reports?
Tell me about Dnamic and Static Dashboards?
What is a Pivot?
Define cognos report net?
What is the enterprise class platform architecture of cognos 8?