Answer Posted / smarati

It is active transformation because,

- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition

All the above increases/decreases the number of rows, so SQ
is active.

Thanks
Som

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

1973

---

How to extract sap data using informatica? What is abap? What are idocs?

1124

---

Explain what is informatica metadata and where is it stored?

1008

---

What are the different types of transformation available in informatica.

1051

---

What are the types of caches in lookup?

995

---

What are junk dimensions?

1038

---

Mention some types of transformation?

1010

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1288

---

Could you explain what is enterprise data warehouse?

1083

---

What do you mean by filter transformation?

914

---

Why sorter is an active transformation?

1148

---

What is a repository? And how to add it in an informatica client?

1107

---

What are some examples of informatica etl programs?

908

---

What is the difference between a repository server and a powerhouse?

1441

---

What is a predefined event?

1056

---