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
Enlist the tasks for which source qualifier transformation is used.
How do you update the records with or without using update strategy?
what are the deliverables?in your project?
Define enterprise data warehousing?
How union transformation is used?
tell me the rules and responsblites in our project(my project is development)
Explain the different lookup methods used in informatica?
What is Cognos script editor?
What are active transformations.
Parameter and variable differences
In how many ways we can create ports?
wat are deployement groups in informatica, how it will be used for developers
Explain joiner transformation in informatica
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is the hint? how to use it to reduce the query processing in program?