Answer / 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.

Answer / raj

Even we can achieve this by using DBlink concept
for eg:CREATE DATABASE LINK local
CONNECT TO hr IDENTIFIED BY hr
USING 'local';
here
local is an instance name and hr is a schema name, now you
can access both the databases at a single database and you
can give one single source connection in the session
properties..

When you move from devel to prod how will you retain a variable

1 Answers  

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

what is DSS?

3 Answers  

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

Mention a few design and development best practices for informatica?

0 Answers  

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---