 Related Questions A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.
Latest Answer : An alias is identical to base table with different name. The data in alias is
exactly same as original table/but the different name tricks SQL into accepting
that we are using 2 different tables.
An alias breaks the loop by using the same table ... A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate Latest Answer : Table A having m records and Table B having n records then the cartesian prodcut is mXn. Regards,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in ... A method by which Designer can decide which path to choose when more than one path is possible from one table to another in the universe.
Latest Answer : Context:Contexts are a collection of joins which provide a valid query path for Web Intelligence to generate SQL.Regards,Siva ... A join based on the equality between the values in the column of one table and the values in the column of another. Because the same column is present in both tables, the join synchronizes the two tables.
Latest Answer : it is also called INNER JOIN ... A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.
Latest Answer : Relational operation that causes two tablesCheers,Sithu ... A situation that occurs when more than one path exists from one table to another in the universe.
Latest Answer : A loop is a situation that occurs when more than one path exists from one table to another. Loops result in ambiguity in the design of a universe. Designer enables you to identify loops in one of two ways:aliesContextsCheers,Sithu ... A join that links two tables, one of which has rows that do not match those in the common column of the other table.
Latest Answer : Outer Join - method of retreiving selected rows from one table that doesn't match rows with the other table.Ex: Consider A & B two tablesSELECT eno, ename, a.dno, dname FROM a,bWHERE a.dno=b.dno;Output:Eno ... The graphical component within the main Designer window that lets you create the classes and objects of the universe from the tables and columns of a database.
Latest Answer : Table Browser is an independent window that displays the table available in the connected database.You can insert the tables into structure pane by double clicking the tables in the table browser r by selecting the table & dragging it into structure ... Can anyone enlighten me:While connecting 2 subject oriented data mart for example SALES & MARKETING, Can anyone enlighten me:While connecting 2 subject oriented data mart for example SALES & MARKETING, thru common key, but the common dimensional table name alone (not the structure or columns in the table) is different say (year_sal_dim & period_fin_dim). Is it possible to link the datamart. if yes how to solve it. Explain. Read Answers (2) | Asked by : Suresh I have a Worker table that has a Nationality code column (10 codes, one for domestic and 9 for international), how to creat a dimension that gives me only wither the code is domestic or international) Read Answers (1) | Asked by : Isa Ashour
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
