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 is pmcmd command?
What do you mean incremental aggregation?
While migrating the data from one environment to another environment how would you manage the connections?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are Dimensional table?
How can a transformation be made reusable?
When do you use sql override in a lookup transformation?
How you can differentiate between connected lookup and unconnected lookup?
What is InformaticaPowerCenter?
What is a difference between complete, stop and abort?
State the differences between sql override and lookup override?
Tell me about MD5 functions in informatica
How do you load only null records into target?
Define update strategy?
How can you validate all mappings in the repository simultaneously?