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 |
What are the different types of important services used in cognos?
Is it possible to create drill through access to other report from PDF report?
How do add dynamic titles in PP?
pls ans what are the filters we have in framework manager? filters in report studio?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
i would like enter some empty space after every 3 rows how is it possible....?
-------What are the Adv of Star Schema and Snow Flake Schema?
Can we install cognos on windows 7?
what is the difference between list sequel and cross tab sequel?
Which service handles requests for cognos connection,query studio and event studio.
what is the difference between java script and html in cognos?
hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...