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
What are the new features of Power Center 5.0?
what is unit testing?tell me proceedure
What is a stored procedure transformation?
Write the prerequisite tasks to achieve the session partition?
Separate from a database, an information bazaar, and an information stockroom?
What is source qualifier transformation in informatica?
Differences between connected and unconnected lookup?
waht type of interface is used for testing the data in informatica
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to create a non-reusable instance of reusable transformations?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How are indexes created after completing the load process?
Target increases every day even though no new record was inserted
How do you migrate data from one environment to another?
How might one distinguish in the case of mapping is right or not without associating session?