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 […]
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 […]
Replication is a server-based tool that you can use to synchronize data between two or more databases. Replication can send data from one SQL Server instance to another There are 3 types of Replication Snapshot Replication Snapshot replication is also known as static replication. Snapshot replication copies and distributes data and database objects exactly as they […]