![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() 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 : Actually, What happens in the back end (i.e) in database end, while alias is performed, whether it points to one table or too many table. How the performance will be in universe level.Please help me by explaining with this concept correctly, because ... 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 : A context is a rule by which Designer can decide which of two paths to choose when more than one path is possible from one table to another. Contexts can be used to resolve loops in the universe.You can create contexts manually, or cause them to be detected ... 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||