Here comes one more challenging yet interesting topic to tide over. The requirement goes something like this: You have some sources, let it be some sales data or some Call center data coming from different sources. Data can be of different media. But you are able to load it in your staging tables i.e. one staging database you are maintaining like StageDB for storing these incremental data.

So, here we have both master i.e. Dimensional data and Detail i.e. Fact data in our stage database. But before processing further and loading it into our Mart or Data warehouse, we need to check if there is any redundancy at the row level for each of these tables in the staging database. Here comes the main problem, what if you don't know how many tables are there in the staging database and how many columns are there for each table in the staging database but still you have to keep only unique records for each table.


This means there must be some mechanism to deal with this problem dynamically, i.e.

It has to detect the number of tables for the StageDB database.
It has to detect all the columns for each table in the StageDB database.
It has to detect only the redundant records for each table in the StageDB database.

• Godsw SQL Compare 2.4.4
  What is Godsw SQL Compare? Godsw SQL Compare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. Godsw SQL...

• BlackBerry Database Viewer 1.4
  View any desktop database on BlackBerry Device

• DBConvert for Access & MS FoxPro 3.1.0
  DBConvert for MS Access & MS FoxPro is a database migration tool for data conversion from MS Access to MS FoxPro and from MS FoxPro to MS Access databases. You can convert MS Access data to MS FoxPro or MS FoxPro to MS Access databases simply by...

• SQL Partition Manager 2.0.16
  SQL Partition Manager is a solution for managing SQL Server partitioned tables

• MSSQL Server to MySQL Migration 2.0.1.5
  Advanced MSSQL to MySQL database migration software is robust, flexible and economical application used to convert bulk or selected database records created in Microsoft SQL database to MySQL database server in few minutes. MSSQL Database to MySQL Conversion tool provides an efficient way to convert MSSQL database to MySQL format without any...

• DBConvert for FoxPro & MSSQL 2.0.2
  DBConvert for MS FoxPro & MS SQL is a database migration tool for data conversion from MS FoxPro database to MS SQL server and MS SQL db to Microsoft FoxPro

• DBConvert for FoxPro & MySQL 2.1.0
  DBConvert for MS FoxPro & MySQL is a database migration tool for data conversion from MS FoxPro database to MySQL server and MySQL db to Microsoft FoxPro. You can convert FoxPro to MySQL or MySQL to FoxPro simply by configuring several options...

• DBConvert for MS SQL & PostgreSQL 1.1.0
  DBConvert for MS SQL & PostgreSQL is a database migration tool for data conversion from MS SQL to PostgreSQL and from PostgreSQL to MS SQL databases