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 names of the reports that you prepared?
what are the features in cognos8ui
what is the role of cognos comsultant?what actually it means?pls reply
What is a dashboard in Cognos Report Studio and how do we creae it
wat is bus schema?
how many types of variables in cognos report net and cognos 8
Can you define transformer?
how many types of keys are there i.e primary key and foreign key etc..?
New coloums are added in database, then how you know in report level
is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
wt is scope relationship?