Interested to Buy Any Domain ? << Click Here >> for more details...
what is a join? what are the types of joins?
- 5 Answers
- 10302 Views
- HCL, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 4 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
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)
| Is This Answer Correct ? | 0 Yes | 2 No |
How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?
Define query studio?
-----------With out using DrillThrough how to do Reports?
How can we find out cardinality between two tables?
what is drill down and slicing and dicing what are the difference between them?
How can we create regular dimensions & measure dimensions?
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?
any difference between cognos and real time cognos
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
How can we migrate from Businees Objects reports to Cognos 8.x??
Explain what is the difference between native sql and cognos sql?
whis meant by Thumbnails on cagnos?
Teradata 
