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
Describe an informatica powercenter?
Explain the types of transformations?
How do you load alternate records into different tables through mapping flow?
explan ur project architecture?
What are ETL Tools?
What are the measure objects?
What is option by which we can run all the sessions in a batch simultaneously?
Explain in detail about scd type 1 through mapping.
Explain transaction control transformation in informatica
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How you know when to use a static cache and dynamic cache in lookup transformation?
Write the different tools in the workflow manager?
What is a filter transformation?
How you can differentiate between connected lookup and unconnected lookup?
Informatica Checkpoints