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
- 6581 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 the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Is there any target staging area in informatica not staging area
Differences between connected and unconnected lookup?
Informatica settings are available in which file?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Enterprise data warehouse your projects phase by phase explain?
what is size of u r database?
What are the types of lookup transformation?
How many ways are there to do 'remove duplicate records in informatica'?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to update source definition?
Mention few advantages of router transformation over filter transformation.
How to load last n records of file into target table - informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What do mean by local and global repository?
