top button
Flag Notify
Site Registration

How to compare two DB having same structure different data?

+1 vote

Two tables from two different databases are there . both having same structure but different data . how to compare these two tables ?

posted Jul 6, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

source analyzer right click on source table click on compare by this you can get

answer Jul 9, 2015 by Shweta Singh
Similar Questions
+1 vote

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

0 votes

How to use a workflow for one to one mapping for more than one source with source name as parameter with different source structure in Informatica power Center. I have a data migration where i need to unload 800 tables into delimited text files. Is there a way we can give the table name in parameter while running the workflow and the data will be unloaded to the output text file. Need help.