two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?

Answer Posted / venu

by using seeion parameters

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dimensional table? Explain the different dimensions.

877


Did u used latest transformations of 8.6.0? for what?

1634


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1701


What all join we can perform in LOOKUP transformation?

736


What are the informatica performance improvement tips

810






IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

764


Different sorts of metadata that stores in the storage facility?

759


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1343


What are the different types of transformation available in informatica.

818


What is session task and command task?

831


What are the databases that informatica can connect to windows?

784


What is a pre-defined event and user-defined event?

755


What are the differences between a connected lookup and unconnected lookup?

815


What is blocking transformation?

898


Can u generate reports in Informatica?

817