what is a join? what are the types of joins?
Answer Posted / palzkumar
Both are right.. but slight changes... joins is used to
fetch the records/data item from two or more queries (no
tables in cognos) using
type of joins like...
1.EQUI / SIMPLE JOIN (eg. 1:1 = 1:n)
2.SELF JOIN
3.OUTER JOIN
a.left outer join (eg. 1:0 = 1:n)
b.right outer join (eg. 1:1 = 1:0)
c.full outer join (eg. 1:0 = n:0)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How can I schedule reports in cognos?
What are the themes in a data warehouse?
What are query items?
What do you mean by Drill down and Drill Up?
What is the model filter?
how to explain health care project and which reports we can create in health care doain?
How create measures and demensions?
How can we Maintain the Cube Security by Category level and Dimension level ?
What is looping and how to avoid it in framework manager?
What is the difference between the standard and metrics folder?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
How to test a cube?
Name the types of report?
What is defined as catalog and types of catalogs in Cognos?
What are the components of the report studio?