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.

what is the Default Source Option For Update Strategy Transformation?

1170

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8130

---

Explain in detail scd type 2 through mapping.

991

---

What does reusable transformation mean?

1073

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1606

---

What is data transformation manager process?

1080

---

waht type of interface is used for testing the data in informatica

2195

---

How does a sorter cache works?

1002

---

Write the prerequisite tasks to achieve the session partition?

1074

---

What is confirmed fact in dataware housing?

6803

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1007

---

How do you load first and last records into target table?

1101

---

how many types of dimensions are available in informatica?

1001

---

What is a stored procedure transformation?

993

---

How to convert multiple rows to single row (multiple columns) in informatica

1319

---