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
Where do we use mapping variables in informatica?
What is the format of informatica objects in a repository?
Can you use flat files in Mapplets.
What are the differences between a connected lookup and unconnected lookup?
What is different between the data warehouse and data mart?
What are the new features of informatica 9.x developer?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Enlist the differences between database and data warehouse.
Explain what are the different types of transformation available in informatica.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Differentiate between joiner and lookup transformation?
What are the data movement modes in informatica?
What does refresh system mean, and what are its distinctive choice?
What is the difference between a repository server and a powerhouse?
What is the procedure for creating independent data marts from informatica 7.1?