what is a join? what are the types of joins?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the information present in the cognos configuration file?

545


What are the two types of framework manager?

694


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3927


what is the procedure for scheduling conditional rendering?

2020


How do you improve the performance of the Cognos Analytics report

550






how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

3474


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1730


Can you define metrics designer?

616


what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

1711


explain how to create powerplay reports?

615


What are the types of hierarchies?

568


What is Online View?

1576


--------------Diff b/w ODS and OLAP?

2767


What is a Cube?

697


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?

2165