Answer Posted / ravi

select * from table_name pivot(sum(sales) for region in(1,2));

What is a filter transformation and why it is an active one?

970

---

Informatica settings are available in which file?

993

---

difference between informatica 8.1.1 and 8.6

3678

---

What is a snowflake schema?

997

---

What are the differences between oltp and olap?

973

---

what is the complex transformation you used in informatica

2589

---

Explain how many types of dimensions are available in informatica?

1099

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

---

How can you validate all mappings in the repository simultaneously?

1372

---

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

2112

---

What is data transformation manager process?

1166

---

How might you approve all mappings in the archive all the while?

1019

---

How to go to the older version for a mapping?

1101

---

Explain the informatica workflow?

1074

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2060

---