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

Answer Posted / shobana

Joiner transfomation is used to join two differned soures
from the same database. Lookup transformation and
expressions(if needed) can be used to compare data from two
different two differebt types of sources.

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

699


What are the different types of repositories created using informatica?

758


How do you load unique records into one target table and duplicate records into a different target table?

827


where to store informatica rejected data?

766


Can we create multiple integration service on single repository?

801






What does command task mean?

696


Have you worked with/created Parameter file

1315


How an expression transformation differs from aggregator transformation?

709


Differentiate between reusable transformation and mapplet.

700


What are the components of workflow manager?

674


Enlist some properties of sessions.

729


What are the informatica performance improvement tips

705


How we can use union transformation?

694


What is an aggregator transformation?

721


Clarify the utilization of aggregator cache record?

657