Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 11171 Views
- I also Faced
- E-Mail Answers
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
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different transaction levels available in transaction control transformation?
Slowly changing dimensions, types and where will you use them
Which development components of informatica have the highest usage?
How an expression transformation differs from aggregator transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain scd type 3 through mapping.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a connected transformation?
what is degenerated dimension?
Explain lookup transformation is active in informatica
What is the surrogate key?
How to load the data from a flat file into the target where the source flat file name changes daily?
How many ways are there to create ports?
What is the procedure for creating independent data marts from informatica 7.1?
