HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

Answer Posted / vams_gk

shortcut join :it is direct join between source and
destination
example :country-->region--.city

we can coneect country and city using shortcut join

theta join :non equality condition between two tables

Is This Answer Correct ?    6 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

591


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1972


Can we configure two instances of CMS pointing to two different CMS system databases?

1493


What is the difference between slice and dice and cross tab report?

607


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2403






If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

696


Explain in detail about type 1?

659


what will be the contents for a functional requirements specifications

1790


Explain the difference between detect alias and detect context?

629


What would you consider as your biggest achievement and why?

619


Did you face any problems while creating reports? Name? Solutions?

3260


What is thumbnail?

580


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

606


Explain in detail about type 2(scd),

598


What three things do you consider to be the most important factors for a manager?

602