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

1283

---

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

1061

---

What is Data Caches size?

1053

---

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

1083

---

Explain load alternative records / rows into multiple targets - informatica

1115

---

Explain lookup transformation in informatica

1027

---

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

975

---

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

1117

---

Explain about cumulative Sum or moving sum?

995

---

Explain lookup transformation source types in informatica

1060

---

What is a transaction control transformation?

1158

---

Define mapping and session?

992

---

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

1451

---

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

1039

---

What are ETL Tools?

1064

---