what is a join? what are the types of joins?
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
------------ Diff b/w MemberCaption and MemberDescription?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
where you can save the report net documentation in our local system?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
Mention the difference between ‘macros’ and ‘prompt’?
What r the names of the reports that you prepared?
Can you define drill down and drill up?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate how you provide security to reports? How you provide security to packages ? Can you define a query subject? Name the types of gateway? What is the difference between static and dynamic conditions? How can we create a dynamic column name in cognos? Can you define snapshot? how many notations are posible(cordinolity)are there in
between two tables(one is fact and another is dimension)pls
give me a example pls.