![]() 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 ... An object qualified as a detail provides descriptive data about a dimension object. A detail object cannot be used in drill down analysis.
Latest Answer : A Detail object provides additional information about a particular dimension. A Customer dimension, age, fax, phone number, street address and direct mail are typical details. Details and attributes may supply users with additional ways to analyse the ... An object being tracked in multidimensional analysis; the subject of the analysis. Dimensions are organized into hierarchies.
Latest Answer : A dimension is an object that is a focus of analysis in a query. A dimension maps to one or more columns or functions in the database that are key to a query. For example Country, Sales Person, Products, or Sales Line. ... 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 ... An object that is derived from an aggregate function. It conveys numeric information by which a dimension object can be measured.
Latest Answer : An object derived from aggregate function, that is know as mesure objectCheers,Sithu ... A component that maps to data or a derivation of data in the database. For the purposes of multidimensional analysis, an object can be qualified as a dimension, detail, or measure. Objects are grouped Latest Answer : Object is nothing but templet of a class ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||