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)

how u create security to reports ????

10 Answers   iFlex, iGate,

---

what is model and how to create model and how to test model?

8 Answers   IBM,

---

What are variable report studio?

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,

---

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

0 Answers   IBM,

---

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

0 Answers   IBM,

---

What are the different type of securities can we apply in framework manager?

1 Answers  

---

what is report studiio and how to start it?

2 Answers  

---

what are burst options you have?

2 Answers   HCL, IBM, TCS,

---

What is the use of powerplay web viewer in cognos?

0 Answers  

---

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers  

---

What is the difference between group and associare?

0 Answers  

---