Interested to Buy Any Domain ? << Click Here >> for more details...
i have two sources both is oracle database . one is coming
from USA database and another one is coming from U.k
database .i am using source qualifier transformation to join
this.as that time in session level source properties which
path i need to give to retrieve that data.
thanks
bala
09619894486
- 2 Answers
- 7413 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / raj
Even we can achieve this by using DBlink concept
for eg:CREATE DATABASE LINK local
CONNECT TO hr IDENTIFIED BY hr
USING 'local';
here
local is an instance name and hr is a schema name, now you
can access both the databases at a single database and you
can give one single source connection in the session
properties..
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Why do we need informatica?
What is a code page?
Enlist few areas or real-time situations where informatica is required.
How an expression transformation differs from aggregator transformation?
Does an informatica transformation support only aggregate expressions?
What happens when a session fails and you click on recover?
What are the designer tools for creating transformations?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is sq transformation?
What is the use of code page?
Difference between Target-based loading and constraint-based loading?
Write the unconnected lookup syntax?
How to update source definition?
Explain the aggregator transformation?
Differentiate between Load Manager and DTM?
