two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
Answer Posted / 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 |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Clarify the aggregator change?
Where are the source flat files kept before running the session?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How do you load alternate records into different tables through mapping flow?
expain about the tune parameters?
What are the tasks that source qualifier perform?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the difference between router and filter?
How to do the error handling of if ur source is flatfiles?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the meaning of decode in informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
How do you remove duplicate records in informatica? And how many ways are there to do it?