Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Can more than 1 metric be applied on an analytic in business objects?

2222


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1265


What is the difference between datawarehousing and businessintelligence?

1142


what is universe null

2463


What is package in BO

3249


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

1934


What is the profile and package?

2344


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2241


What are the steps to do to use alerts in bo?

1442


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1070


how to prepare the documentation in business objects and where to get the requirement?

2281


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3884


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1034


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

1051


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

2964