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
- 6698 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
Write the unconnected lookup syntax and how to return more than one column.
What is a sequence generator transformation?
Please let me know how to make encryption and decryption with example?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the difference between mapping parameter and mapping variable?
What is the procedure for creating independent data marts from informatica 7.1?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain the scenario which compels informatica server to reject files?
How to go to the older version for a mapping?
Which development components of informatica have the highest usage?
Different circumstance which drives informatica server to expel records?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What does reusable transformation mean?
When do you use sql override in a lookup transformation?
Differentiate between Load Manager and DTM?
