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
- 7118 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
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?
What is a dimensional model?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
r u done any partitions in ur project?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain your project of banking domian.
What is meant by lookup transformation?
What does reusable transformation mean?
How can one identify whether mapping is correct or not without connecting session?
lookup transformation with screenshots
scenario where i can use only concurrent execution of workflow.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Mention a few design and development best practices for informatica?
whats the logic to load the lower level of granularity of data to fact table.
