Answer Posted / bidhar

Sources should be Homogeneous.Though they might not have a
joining condition.
For Example If you have Employee table and Dept Table and
the joining condition is on deptid then its not mandatory
that you must specify the joining condition.If you dont
specify the joining condition then it will have a cartesian
join.

Also the Ports Serial should be same as the SQ override
select.

How many number of sessions can one group in batches?

1114

---

What are junk dimensions?

1036

---

What is the difference between router and filter?

1177

---

What is joiner transformation in informatica?

1002

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1240

---

How to elaborate tracing level?

1128

---

How do you change a non-reusable transformation to reusable transformation?

960

---

What is mapplet in informatica?

997

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2059

---

update strategy transformation in informatica

1027

---

wf dont have integration severances how you can run?

1895

---

Which files are created during the session rums by informatics server?

1137

---

What are the reusable transformations?

1110

---

Explain the use of aggregator cache file?

1200

---

Explain dynamic target flat file name generation in informatica

1021

---