Answer / m m naidu

OUTER JOIN: It is used to retrieve all the rows from one
table but matched rows from another table

LEFT OUTER JOIN: It displays matched row from two tables
and unmatched row from left hand side table

EX: select a.empno,a.ename,a.sal,b.deptno,b.dname,b.loc
from emp a left outer join dept b on(a.deptno=b.b.deptno)

RIGHT OUTER JOIN: It displays matched rows from two tables
and unmatched row from right hand side table

EX: select a.empno,a.ename,a.sal,b.deptno,b.dname,b.loc
from emp a right outer join dept b on(a.deptno=b.b.deptno)

hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....

1 Answers   HCL,

---

what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)

1 Answers   HCL, Syntel,

---

What is the difference between drill through, drill across?

0 Answers  

---

what is report view?

4 Answers   Cap Gemini,

---

-------------How you design DWH?

0 Answers   Bank Of America,

---

how you provide security to reports? How you provide security to packages ?

0 Answers   IBM,

---

How many fact tables and dimension tables in your project?

3 Answers   IBM,

---

what is logs in cognos

1 Answers   HCL,

---

Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,

---

suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 Answers  

---

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

1 Answers  

---

What are all the advantages of Cognos?

0 Answers  

---