What is etl process. How many steps etl contains explain with example?

1004

---

What is a staging area? What is the purpose of a staging area?

939

---

What are vaious etl tools in the market?

1057

---

What are the measure objects?

1257

---

What are the different types of transformation available in informatica.

1147

---

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

1252

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1140

---

How to do unit testing in informatica? How to load data in informatica ?

1187

---

Explain the different dimensions.

1010

---

Differentiate between source qualifier and filter transformation?

1634

---

Explain scd type 3 through mapping.

1055

---

What is dimensional table?

1135

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1648

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1182

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1225

---