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

What are the new features of Power Center 5.0?

1460


what is unit testing?tell me proceedure

2007


What is a stored procedure transformation?

830


Write the prerequisite tasks to achieve the session partition?

864


Separate from a database, an information bazaar, and an information stockroom?

850


What is source qualifier transformation in informatica?

769


Differences between connected and unconnected lookup?

897


waht type of interface is used for testing the data in informatica

2042


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3636


How to create a non-reusable instance of reusable transformations?

909


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2155


How are indexes created after completing the load process?

1271


Target increases every day even though no new record was inserted

1365


How do you migrate data from one environment to another?

879


How might one distinguish in the case of mapping is right or not without associating session?

867