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
- 7405 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / zer0
As far as I understand, you have 2 databases (both oracle).
You are trying to join table in say database1 (US) with
table in database2 (UK) using Source Qualifier. If you
really want to join using SQ, then create a view of the
table in db1 into db2 and then try joining the view and the
table in db2. Then in the session you will need to give the
connection setting of only db2.
If you dont like the view idea try using Joiner
Transformation. Joiner Transformation is a stright forward
method in Informatica.
Please let me know if it works.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
What is informatica powercenter repository?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Scheduling properties,whats the default (sequential)
What is the session task and command task?
What is primary and backup node?
What is rank transformation in informatica
is it possible to index the data in cache of lkp transformation ?
What is parallel processing in informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Differentiate between sessions and batches?
What is Data Caches size?
Explain the code page compatibility?
Is it possible to create multiple domains on a single Informatica server?
