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

Answer Posted / sreenu

That is not a correct answer because joiner is used for
joini two tables
so at source analyser right click on sourc table click on
compare by this u can get
this is i have seen some where

Is This Answer Correct ?    9 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between a connected lookup and unconnected lookup?

641


What is the need of an ETL tool?

638


What are some examples of informatica etl programs?

529


What is enterprise data warehousing?

611


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1525






What are the modules in Power Center

1225


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2423


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1177


Explain the different lookup methods used in informatica?

582


What's the layout of parameter file (what does a parameter file contain?)?

1912


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1328


What is repository manager?

530


How to convert multiple rows to single row (multiple columns) in informatica

889


What is pmcmd command?

668


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6398