two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
Answer Posted / janani
We can use lookup Transformation and expression to compare
the data
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is powercenter on grid?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the tasks that source qualifier perform?
What is expression transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Differentiate between a database and data warehouse?
Write the unconnected lookup syntax and how to return more than one column.
Describe data concatenation?
How many ways a relational source definition can be updated and what are they?
Explain your project of banking domian.
What is an expression transformation in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?