Abstract-In a period of scientific advancement, technical innovation and quicker development in modern computing, an unimaginable quantum of data is exchanged, processed, stored, referred to, analyzed, for various purposes. Be it any discipline, industry or branch of study managing data has become unwieldy. A proper organization of data will pave the way for easy access for various desired functions which will in turn determine the success of a company. In these days of an avalanche of data it has become imperative to initiate innovative methods. Great interest and utmost care is taken in this paper to suggest fuzzy optimization to achieve greater accurate and effective solutions. The growth in the number of business looking for data mart solutions, with the aim of adding major business gains, has generated the need for a decision-aid has come near in preferring the right data mart system. Due to the indefinite concept often denoted in decision-making procedure, to facilitate decision matrix analysis, with fuzzy optimization technique which scrutinize the best decision making for sales promotion to the various places. Fuzzy Optimization technique is the symmetric approach of decision making process which is used to demonstrate the maximum sales quantity depending on the places. This paper propose a new FDM (Fuzzy Decision Making) algorithm, to evaluate the performance of sales promotion using Hyper ETL (Extract, Transform and Load) in sales Data Mart.