two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
Answer Posted / sreenu
That is not a correct answer because joiner is used for
joini two tables
so at source analyser right click on sourc table click on
compare by this u can get
this is i have seen some where
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
Explain scd type 3 through mapping.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How do you update the records with or without using update strategy?
What is a shortcut and copy in Informatica and how two are different with each other?
What is domain in terms of informatica?
Is stop and abort are same in informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Define update strategy?
Define the various join types of joiner transformation?
Can anyone tell me the new features in Informatica 9 Version?
What are the differences between a connected lookup and unconnected lookup?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
how to load dimension table and fact table. plz tell me the steps.
What is update strategy transform?