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 is union transformation utilized?

1003

---

What is the Process to creating lookup transformation in informatica

1038

---

What is the use of code page?

1083

---

Describe data concatenation?

1072

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1028

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1984

---

How do you load only null records into target?

1209

---

While migrating the data from one environment to another environment how would you manage the connections?

1080

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1168

---

What are different types of transformations available in informatica?

987

---

How does the aggregator transformation handle null values?

1144

---

Different sorts of metadata that stores in the storage facility?

1008

---

What are ETL Tools?

1110

---

What is a repository manager?

1087

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1114

---