Interested to Buy Any Domain ? << Click Here >> for more details...
two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 25306 Views
- HP, Patni, I also Faced
- E-Mail Answers
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 |
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
What is intricate mapping?
How is union transformation utilized?
Whats there in global repository
scenario where i can use only concurrent execution of workflow.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is a repository? And how to add it in an informatica client?
differences between service based and product based?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
What is the use of an aggregator cache file?
How do you handle two sessions in Informatica
Teradata 
