two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 23275 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 |
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
can you use flat file for lookup table?why?
can every transfomation reusable?how?
Can we override a native sql query within informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
how to load only the first and last record of a flat file into the target?
Can you generate sequence numbers without using the sequence generator transformation?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
What is incremental aggregation?
what is difference between mapping and mapplet ?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
What is status code?
Teradata 
