I have to come up with a test plan for testing a replication process. The source data lies in syabase12 database. through some confguration the data is replicated to sybase15 database. There are no transformations the data is replicated as it is. From Sybase15 it is further replicated to oracle. Again no transformation is applied the dat is replicated as it is.
No the objective of testing is that the data is identical in all the three databases. Since there are differences in the available data types in sybase12, sybase15 and oracle11g the datatype in the destination database is not same as the source. For example char in sybase maybe varchar in oracle and such. Also constraints in the form null allowed and not allowed is found to be not proeprly replicated in the destination dbs.
Currently this testing is done manually using informatica IDE. A profile of the tables is taken out in all these three DBs and then the profile is compared. This is very time consuming process as it sometime takes hours to create a profile of table containing large number of rows.
There are 100 odd table to compare across these three databases.
Can we remove informatica from the picture and test thsi using sql queries and procedures? Please help me devise a strategy.