Answer Posted / sukanta

Drag two tables to mapping designer.Now with two tables two
source qualifier has come to the workspace among which you
delete second source's source qualifier.Now drag all ports
from 2nd source to first source qualifier.Now the first
qualifier have contained all ports of two sources.

But before than that in source analyzer you make a PK-FK
relation between two sources.Now in the source qualifier you
make a join condition upon that two port for PK-FK.

You get the solution.

Regards
Sukanta

How do you manage the Parameter files while migrating your data from one environment to another environment?

996

---

explain about unit testing? in real time?

2179

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1152

---

How can we use batches?

1004

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3684

---

What is the meaning of decode in informatica?

1107

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1023

---

What is the function of union transformation?

1109

---

What are the performance considerations when working with aggregator transformation?

1131

---

Have you worked with/created Parameter file

1648

---

server hot-ws270 is connect to Repository B. What does it mean?

2531

---

Differentiate between joiner and lookup transformation?

1091

---

Explain the types of lookup transformation?

1032

---

How can you differentiate between powercenter and power map?

1070

---

what is mean by complex business rule ?

2144

---