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


Please Help Members By Posting Answers For Below Questions

What is a filter transformation?

671


what is index?how it can work in informatica

1695


Explain the use of aggregator cache file?

798


Write the program through which the records can be updated?

620


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2502






what is unit testing?tell me proceedure

1879


tell me about your project functionality

1970


Define mapplet?

706


Under what conditions selecting sorted input in aggregator will still not boost session performance?

717


What are the informatica performance improvement tips

705


What are the data movement modes in informatica?

793


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1735


What is an Integration service in Informatica?

801


Explain where to store informatica rejected data? How to extract the informatica rejected data?

693


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1751