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

1266

---

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

1036

---

What is Data Caches size?

1035

---

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

1071

---

Explain load alternative records / rows into multiple targets - informatica

1102

---

Explain lookup transformation in informatica

1008

---

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

957

---

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

1100

---

Explain about cumulative Sum or moving sum?

983

---

Explain lookup transformation source types in informatica

1043

---

What is a transaction control transformation?

1145

---

Define mapping and session?

973

---

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

1424

---

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

1024

---

What are ETL Tools?

1043

---