What Are Attribute Roles?

1.	What Are Attribute Roles?
Answer» A user defines two attributes that have the same definition but play different roles in the business MODEL. In this example, attribute Origin Airport and Destination Airport are defined USING the same LOOKUP Table and Column (Airport_ID). Both attributes share the same forms, or information about them (Description, LOCATION, etc.). In the fact table, however, a SEPARATE column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID). A user defines two attributes that have the same definition but play different roles in the business model. In this example, attribute Origin Airport and Destination Airport are defined using the same Lookup Table and Column (Airport_ID). Both attributes share the same forms, or information about them (Description, Location, etc.). In the fact table, however, a separate column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID).

Answer»

A user defines two attributes that have the same definition but play different roles in the business MODEL. In this example, attribute Origin Airport and Destination Airport are defined USING the same LOOKUP Table and Column (Airport_ID). Both attributes share the same forms, or information about them (Description, LOCATION, etc.). In the fact table, however, a SEPARATE column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID).

A user defines two attributes that have the same definition but play different roles in the business model. In this example, attribute Origin Airport and Destination Airport are defined using the same Lookup Table and Column (Airport_ID). Both attributes share the same forms, or information about them (Description, Location, etc.). In the fact table, however, a separate column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID).

What Are Attribute Roles?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment