Interested to Buy Any Domain ? << Click Here >> for more details...
what is a join? what are the types of joins?
- 5 Answers
- 10257 Views
- HCL, Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the components of report net?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What are products of cognos?
Explain what is the difference between native sql and cognos sql?
can we insert all types of charts in a list report? what r the realtime prompts?
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?
Define query items?
Why cognos decision stream is used?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
what is log in cognos?
How to Reset Pagenumbers in one report.
Can you define drill across?
what is model and say about process how to create model and how to test model?
What is the difference between low affinity and high affinity connections?
