Explain direct and indirect flat file loading (source file type) - informatica

1359

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1212

---

What is Data Caches size?

1128

---

How do you promote a non-reusable transformation to reusable transformation?

1179

---

Explain load alternative records / rows into multiple targets - informatica

1206

---

Explain lookup transformation in informatica

1129

---

How many ways a relational source definition can be updated and what are they?

1064

---

What are the differences between joiner transformation and source qualifier transformation?

1238

---

Explain about cumulative Sum or moving sum?

1092

---

Explain lookup transformation source types in informatica

1151

---

What is a transaction control transformation?

1261

---

Define mapping and session?

1089

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1555

---

How to create or import flat file definition in to the warehouse designer?

1131

---

What are ETL Tools?

1171

---