Answer Posted / vinithra

Hi,
Say a Transformation1 accepts input from transformation 2
and passes the output to a transformation 3 , then

transformation 2 is called an upstream transformation.
transformation 3 is called a downstream transformation.
I got this from INFA Help.Please let me know if im wrong!

Thanks.

Enlist the tasks for which source qualifier transformation is used.

1052

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1962

---

how to load dimension table and fact table. plz tell me the steps.

2105

---

Write the unconnected lookup syntax and how to return more than one column.

1121

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6197

---

What do you understand by term role-playing dimension?

1062

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1120

---

What are the tuning techniques you applied during your last project

2040

---

How to extract the informatica rejected data?

1229

---

What is an expression transformation?

1031

---

How will the document be delivered to me?

1093

---

What are Dimensional table?

1073

---

What are the prerequisite tasks to achieve the session partition?

1265

---

What is a pre-defined event and user-defined event?

1051

---

how to load rows into fact table in data warehouse

1202

---