Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

Answer Posted / rakesh

if source n targer exist in
different databases you can
create Database link in any of
the database for other one..

create database link "dblink
name"
connect to schemaname
identified by password
using 'Database name';

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do we use mapping variables in informatica?

607


What is the format of informatica objects in a repository?

592


Can you use flat files in Mapplets.

2211


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

639


What is different between the data warehouse and data mart?

622






What are the new features of informatica 9.x developer?

525


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2132


Enlist the differences between database and data warehouse.

539


Explain what are the different types of transformation available in informatica.

564


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

711


Differentiate between joiner and lookup transformation?

606


What are the data movement modes in informatica?

692


What does refresh system mean, and what are its distinctive choice?

563


What is the difference between a repository server and a powerhouse?

801


What is the procedure for creating independent data marts from informatica 7.1?

557