Answer / mike

If you are performing the join using a SOURCE QUALIFIER ,
the relational sources should have a primary and foreign
key relationship.
If you are performing the join using a JOINER, no need to
have a primary and foreign key relationship.

Answer / usha

we want join in SQ we should have primary key and foreign
key relation ship ...


but, in joiner we dont need primary key and foreign key
relation ship

Answer / bharu_295

if u want to join the tables we need to have primary and foreign key relationship other wise if we join we get Cartesian product of the data.

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

daily how much amount of data send to production?

4 Answers   HSBC,

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

What does cheating measurement mean?

0 Answers  

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

How the Informatica Server reads perameter file?

1 Answers  

---

What are the basic needs to join two sources in a source qualifier?

4 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---