Data mining refers to the process or method that extracts or mines interesting knowledge or patterns from large amounts of data. Thus, the result of the natural evolution of information technology can be viewed by data mining. Data mining also involves assimilation, more willingly than a simple transformation. Data mining also have techniques from multiple directions such as database technology, statistics, machine learning, high-performance computing, pattern identification, neural networks, data revelation, information extraction as well as image and signal processing and spatial data analysis. The large number of database systems having query and transaction processing eventually and naturally led to the need for data analysis and understanding. Hence, due to this increasing necessity data mining started its development. The process reveals hidden patterns that can’t be detected using traditional query and OLAP tools. So there is “Teradata Solution”, unique approach to counselling and our optimal use of data warehouse technology.[4]