Referential Join - This type of join is possible in Calculation Views. It works like an inner join but here referential integrity is maintained, meaning if the columns from the right table are not mentioned in the query then the join will not work and the query gives all records from the left table. It is also known as an immiscible join.
Text Join - Used join with a text table.
Inner Join - Here both the left and right table have a common key called foreign key. It will always return matching records, if there are no matching records found then no records will be produced.
Left Outer Join - Here return all records from the left table and matching records from the right tables.
Right Outer Join - Here return all records from the right table and matching records from the left tables.
Temporal Join - Used join with a time dimension. (M* Tables).
Spatial Join - Used to join coordinates. (Miles, cm, Geographical coordinates)
Star Join - Used to join two star schemas. This join is only used in calculation views.
If you have any Question you can contact us or mail us. We will reply you as soon as possible.
Post a Comment