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
- 6176 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 incremental aggregation in informatica
What is Data Caches size?
What are junk dimensions?
What is a difference between complete, stop and abort?
What is a dimensional model?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is informatica? Why do we need it?
What is the use of target designer?
Define mapplet?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to delete duplicate row using informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the differences between a connected lookup and unconnected lookup?
What is an aggregator transformation?
