International Journal of Engineering Sciences & Research Technology (IJESRT)
The successful organization is the result of the successful decisions made by the top management. These are the collaborated decisions and require a lump sum data or the consolidated view of organization, which is provided by data warehousing system. These systems are used as an organization repository to support strategic decision making. Data schema represents the arrangement of fact table and dimension tables and the relations between them. In data warehouse development, selecting a right and appropriate data schema (snowflake, star, star cluster etc.) has an important Impact on performance and usability of the designed data warehouse.