what is a join? what are the types of joins?
Answers were Sorted based on User's Feedback
Answer / m m naidu
JOIN: A join is a query using which we can query data from
more than one table
TYPES OF JOINS:
1.EQUI JOIN
2.SELF JOIN
3.OUTER JOIN
a.left outer join
b.right outer join
c.full outer join
4.cartesian join
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / arkchowdary
Join----------------- Ajoin is fetch the data 1 or more
tables this is known as join.
Types of Joins-------------- Equi Join,
Nonequi join,
Self Join,
Cartesoin Join,
Outer Joins
Leftouter Join,
Rightouter join,
Full outer Join.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
can we insert all types of charts in a list report? what r the realtime prompts?
What are the other methods working as deployment functionality?
how to Explain a complex report at the time of interview ? please post the answer very urgent?
What is drill down and slicing and dicing whats the difference between them?
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
can we put more measure on cross tab? If so how many? How this affect the aggregation?
How to select all in value prompt instead of cascade prompt?
Difference betwween cognos report net architecture and cognos8 architecture
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)
What are user classes?
1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?
Can you define cube?