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

Answer Posted / sowjanya

If the tables are from two different databases you should
use JOINER to join them.

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of decode in informatica?

754


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1314


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2408


Clarify the utilization of aggregator cache record?

657


Explain pmcmd command usage in informatica

796






Could you explain what is enterprise data warehouse?

646


EXL informatica Questions

1034


What is dynamic cache?

695


What is a mapplet/worklet in informatica?

814


What is informatica etl tool?

643


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1904


How to handle decimal places while importing a flatfile into informatica?

810


Explain in detail about scd type 1 through mapping.

688


How can we delete duplicate rows from flat files?

847


What are the types of schemas we have in data warehouse and what are the difference between them?

613