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 […]
Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command. TRUNCATE TRUNCATE is faster and uses fewer system and transaction […]