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
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?
What are the different types of repositories created using informatica?
How do you load unique records into one target table and duplicate records into a different target table?
where to store informatica rejected data?
Can we create multiple integration service on single repository?
What does command task mean?
Have you worked with/created Parameter file
How an expression transformation differs from aggregator transformation?
Differentiate between reusable transformation and mapplet.
What are the components of workflow manager?
Enlist some properties of sessions.
What are the informatica performance improvement tips
How we can use union transformation?
What is an aggregator transformation?
Clarify the utilization of aggregator cache record?