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
explain how to create powerplay reports?
how to explain health care project and which reports we can create in health care doain?
what is a prompt value in report studio and variables ?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
2. What functional area you worked on.
What is the difference between Open Connection command ang Open Session Command?
How the Bursting happens in same report and how to Print the bursting Report?
What are the two types of framework manager?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What is difference between content store and content manager?
what is power prompt in cognos ep7series?what is the use of this?
Write various indexes used in cognos?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What is the size of database for you project?
What is Metrics designer?