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 |
Which version configuration tool used in ur project?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
Types of error logs in Informatica?
Explain about Informatica server process that how it works relates to mapping variables?
how to through logic of informatica using the push down optimization into oracle.
Is snow flake or star schema used? If star schema means why?
How to update or delete the rows in a target, which do not have key fields?
What are the prerequisite tasks to achieve the session partition?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai