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.

What is confirmed fact in dataware housing?

6958

---

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.

1634

---

Is there any target staging area in informatica not staging area

2576

---

How to configure mapping in informatica?

1172

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1624

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1161

---

What is a difference between complete, stop and abort?

1078

---

What are different types of transformations available in informatica?

987

---

Explain about cumulative Sum or moving sum?

1037

---

r u done any partitions in ur project?

1826

---

Explain the mapping variable usage example in informatica

1155

---

How will the document be delivered to me?

1074

---

What does role playing dimension mean?

1044

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1249

---

What is the way to execute pl/sql script using informatica mapping?

1597

---