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

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8171

---

What are the differences between source qualifier and joiner transformation?

996

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

984

---

What are active transformations.

1596

---

What is a predefined event?

1037

---

What are the different components of powercenter?

986

---

Differentiate between a database and data warehouse?

1093

---

What is lookup transformation?

1004

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7318

---

Explain what are the different types of transformation available in informatica.

1039

---

What is an active transformation?

1038

---

Which transformation is needed while using the Cobol sources as source definitions?

1128

---

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

1173

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2077

---

Difference between Target-based loading and constraint-based loading?

946

---