what is a join? what are the types of joins?
Answer Posted / 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 |
Post New Answer View All Answers
What is the metric store database?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What is the difference between group and associare?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
Can you explain new content durability?
How to test a cube?
Diff b/w Crossproduct and Outerjoin?
write a query to display the departments with no employee?
How to join multiple db in catalog?
What do you understand by ‘ibm predictive maintenance and quality’?
Why is auto-regression used in forecasting used on cognos platform?
What are the types of hierarchies?
What is the function of cognos dispatcher?
Write some methods to apply securities in framework manager model?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........