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
- 7111 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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How many transformations can be used in mapplets.
Explain constraint based loading in informatica
Why filter transformation is an active one?
what is the Default Source Option For Update Strategy Transformation?
How you prepared reports for OLAP?
Differentiate between sessions and batches?
What are connected or unconnected transformations?
What is meant by lookup transformation? Explain the types of lookup transformation?
Define mapplet?
What are the different versions of informatica?
What is a connected transformation?
how we can load rejected record's at run time?(not through bad files)
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
