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

Answer Posted / sreenu

That is not a correct answer because joiner is used for
joini two tables
so at source analyser right click on sourc table click on
compare by this u can get
this is i have seen some where

Is This Answer Correct ?    9 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you validate all mappings in the repository simultaneously?

896


What is a stored procedure transformation?

687


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

793


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1956


What is a grid in Informatica?

716






Explain sessions. Explain how batches are used to combine executions?

693


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1556


How to use pmcmd utility command?

684


Define sessions in informatica etl?

701


Reusable transformation and shortcut differences

1465


How to differentiate between the active and passive transformations?

709


How to extract sap data using informatica?

692


What is mapplet in informatica?

669


What is difference between a gateway node and worker node?

734


What are active transformations.

1290