A compound attribute is defined as an attribute with more than one column specified as the ID column. This implies, of course, that more than one ID column is needed to uniquelyidentify the elements of that attribute. Generally, you build a compound attribute when your logical model reflects that a compound key relationship is present.
For example, a retail project has two attributes, Class and Item. Class is the parent of Item and has a one-to-many relationship with it. The values in the Item_ID column do not uniquely identify an item. The item shirt has an Item_ID of 1. However, there are different shirts, depending on theclass—men’s, women’s, and children’s. Therefore, to uniquely identify a man’s shirt, Item_ID and Class_ID must be grouped together, creating a compound attribute.
All of the ID forms of the compound attribute should be grouped together. They should also use the same lookup table.
Microstrategy Related Interview Questions
|Informatica Interview Questions||IBM Cognos Interview Questions|
|Teradata Interview Questions||Adv Java Interview Questions|
|Cloud Computing Interview Questions||SQL Database Interview Questions|
|OBIEE Interview Questions||Qlik View Interview Questions|
|Tableau Interview Questions||Talend Interview Questions|
|IBM Cognos TM1 Interview Questions||Data modeling Interview Questions|
|Cognos ReportNet (CRN) Interview Questions||Qlik Sense Interview Questions|
Introduction To Advanced Reporting
Creating Freeform Sql Reports
Creating Olap Cube Reports
Data Mining Services
Custom Groups And Consolidations
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.