-------------Diff b/w Union and Unionall?
- 3 Answers
- 8550 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sridevi
UNION will give only distinct values where as UNION ALL gives all the values including duplicates.Performance wise UNION ALL is faster than UNION because UNION needs to exclude duplicates.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is model and say about process how to create model and how to test model?
Define the slice and dice?
Can you define cognos impromptu?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
tell me two or three issues from client side and how to solve those issues?
What is the size of database for you project?
What errors and types of errors you faced in Cognos ReportNet?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What is the model filter?
write a query to display the departments with no employee?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is the use of powerplay web viewer in cognos?
WHAT ARE THE DISTNICT VARIABLES?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
