What is Outerjoin?
Answers were Sorted based on User's Feedback
Answer / rakesh
By using outer join we have to display both the matching and non matching records from both the sides(tables).
and in this we have three conditions
left,right and full outer joins.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amar
Outer join means, Suppose we have two tables like A and B.
Outer join returns Non Matching columns from both tables.
Is This Answer Correct ? | 0 Yes | 2 No |
When we deploy the report to live the client get the data error how can we resolve that
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
how will optimiz the performance of sql in FM ?
What is parameter maps & Session parameter?
What do you understand by the term 'aggregate advisor?'
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What are differences between Reporter report and Explorer report?
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
Where in report Studio's property pane can I find NoDataHandler?
hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....
How to hide the prompts
what is slowly growing dimension??