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

Answer / uma

What about inner join?is it not included?

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.

Answer / abd hfz

Inner join is also called as Equi Join.

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)

can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  

What are the other methods working as deployment functionality?

0 Answers  

how to Explain a complex report at the time of interview ? please post the answer very urgent?

3 Answers   HSBC, IBM, TCS,

What is drill down and slicing and dicing whats the difference between them?

0 Answers  

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.

4 Answers   TCS,

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  

How to select all in value prompt instead of cascade prompt?

3 Answers   IBM,

Difference betwween cognos report net architecture and cognos8 architecture

3 Answers  

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)

2 Answers  

What are user classes?

1 Answers   HCL,

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?

3 Answers  

Can you define cube?

0 Answers