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
What are the differences between a connected lookup and unconnected lookup?
What is the need of an ETL tool?
What are some examples of informatica etl programs?
What is enterprise data warehousing?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the modules in Power Center
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?
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 ?
Explain the different lookup methods used in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is repository manager?
How to convert multiple rows to single row (multiple columns) in informatica
What is pmcmd command?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?