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

Answer Posted / sowjanya

If the tables are from two different databases you should
use JOINER to join them.

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6848


How you can differentiate between connected lookup and unconnected lookup?

808


how to load dimension table and fact table. plz tell me the steps.

1850


How can we remove the duplicates from flat file source?

770


How do you promote a non-reusable transformation to reusable transformation?

886


What is meant by a domain?

829


what are factless facts? And in which scenario will you use such kinds of fact tables.

1509


How can you define user defied event?

814


What does “tail –f” command do and what is its use as an Informatica admin.

833


update strategy transformation in informatica

812


What are the designer tools for creating transformations?

872


define galaxy repository in informatica

1919


Explain your project of banking domian.

1382


What is a joiner transformation and why it is an active one?

753


What are the types of lookup transformation?

827