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

Answer Posted / baalu

If u want to compare the data present in the tables go for
joining and comparison..
if u want to compare the metadata (properties)of the tables
to for "compare Objects" in source analyser/

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are connected or unconnected transformations?

875


What is the use of source qualifier?

890


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10464


When do you use sql override in a lookup transformation?

796


can you please explain me pre session and post session options?

6954


What is repository manager?

776


What is the way to execute pl/sql script using informatica mapping?

1263


What is meant by a domain?

864


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1752


What are the performance considerations when working with aggregator transformation?

923


What does “tail –f” command do and what is its use as an Informatica admin.

858


Explain pushdown optimization $pushdownconfig parameter - informatica

930


What is sequence generator transformation in informatica?

841


What is meant by pre and post session shell command?

867


What is meant by lookup transformation? Explain the types of lookup transformation?

753