two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
Answers were Sorted based on User's Feedback
Answer / baalu
If u want to compare the data present in the tables go for
joining and comparison..
if u want to compare the metadata (properties)of the tables
to for "compare Objects" in source analyser/
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / janani
We can use lookup Transformation and expression to compare
the data
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / 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 |
Answer / bsgsr
if ur comparisiom means joining it shud be using joiner
t/tion using a join condition and join type
Is This Answer Correct ? | 2 Yes | 4 No |
Answer / 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 |
Answer / srinivas chowdary
If the Tables from two different datbases we should go with
Joiner Transformation.
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / ram kumar
Using Joiner Transformation, to compare the two tables.
Is This Answer Correct ? | 7 Yes | 12 No |
Answer / sowjanya
If the tables are from two different databases you should
use JOINER to join them.
Is This Answer Correct ? | 2 Yes | 8 No |
Why we use stored procedure transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the difference between a connected look up and unconnected lookup?
what is a time dimension? give an example?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is partioning?how many types of partinings are there
how i will stop my workflow after 10 errors
How to call shell scripts from informatica?
how can we calculate fact table size?
why we r using presql&postsql in source qualifier?
difference between informatica 8.1.1 and 8.6
What is the capacity of power cube?