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
- 7139 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
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
what is informatica metadata?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain the tuning lookup transformation - informatica
Briefly define reusable transformation?
How big was your fact table
How an expression transformation differs from aggregator transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to create a non-reusable instance of reusable transformations?
what is size of u r database?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
what is diff b/t sorter t/r and agg have the option sorter property...
Explain the use of aggregator cache file?
What are the performance considerations when working with aggregator transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
