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)

What is defined as data mining?

0 Answers  

In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

0 Answers   TCS,

What are all the types of hierarchies?

0 Answers  

2. What functional area you worked on.

0 Answers   IBM,

-------------How to create a PortalTab?

1 Answers   Cap Gemini,

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

6 Answers   HCL,

What is the difference between static and dynamic conditions?

0 Answers  

I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos

1 Answers   IBM,

what are determinants?

4 Answers   Dominion,

What is main difference mapplets and mapping?

0 Answers  

Can you define a catalog and types of catalogs in cognos?

0 Answers  

what is loop in frameworkmanager ?

4 Answers   Texas,