Data warehouse is one of the most rapidly growing areas in management information system. With this approach, data for Executive Information System (EIS) and Decision Support System (DSS) applications are separated from operational data and stored in a separate database. This process is called data warehousing. The major advantages of this approach are: improved in performance, better data quality, and the ability to consolidate and summarize data from heterogeneous systems. A data warehouse is part of a larger infrastructure that includes legacy data sources, external data sources, a repository, data acquisition software, and user interface and related analytical tools. The aim of this research work is to elaborate that how the textile industry can manage and improve their production capacity and resources at optimum level to produce a good quality result using data warehousing and data mining techniques. This research work is conduction in Masood Textile Mills Limited, Faisalabad, Pakistan (MTML). The results may hopefully opened-up an era of research and methodology that could further benefit the Industry to support in decision support system.