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
- 25017 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 |
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Explain the features of connected and unconnected lookup.
can you please explain me pre session and post session options?
How many number of sessions that u can create in a batch?
What all join we can perform in LOOKUP transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Is it possible to create multiple domains on a single Informatica server?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
What is a grid in Informatica?
what is the size of your data warehousing?
What is fact table? Explain the different kinds of facts.
what is normalization? explain 1st NF, 2nd NF, 3rd NF
Teradata 
