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
Explain the difference between a data warehouse and a data mart?
What is joiner transformation in informatica?
How to update or delete the rows in a target, which do not have key fields?
Under which circumstances, informatica server creates reject files?
What is the use of an aggregator cache file?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the data movement modes in informatica?
What is workflow? What are the components of workflow manager?
What is a rank transform?
In how many ways we can create ports?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are pre and post-session shell commands?
What is the difference between stop and abort in informatica
Differences between version 7.x and 8.x.