There are situations where you are faced to create index on a really huge table. This can be really troubling because it’s no joke at all and it can cause you headache for weeks to even attempt to start creating the index on the table. I have experienced this on many occasions and l have […]
This is one common thing you will find on lot of websites. I always think of it as encouraging people to visit the site because knowing number of people on the website might motivate visitors to often visit the site. For example, if you have a social network and you want to create that statistical […]
The primary goal of Data Quality solution is to assemble data from one or more data sources. However, the process of bringing data together usually results in a broad range of data quality issues that need to be addressed. For instance, incomplete or missing customer profile information may be uncovered, such as blank phone numbers […]
It involved 4 Phases: Planning, Designing, Implementation and Maintenance Planning involves Understanding of business requirements and Identifying the scope of whole DW ( is it for reporting or for creating cube) Understanding the heterogeneous sources from where the data is going to pulled and the destinations to which the data is going to. Planning for […]