Explain in detail about scd type 1 through mapping.

1630

---

Write the unconnected lookup syntax?

1133

---

Write the unconnected lookup syntax and how to return more than one column.

1151

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1207

---

What is dimensional table? Explain the different dimensions.

1256

---

What are the types of caches in lookup?

1096

---

What are the types of caches in lookup? Explain them.

1014

---

Differentiate between router and filter transformation?

1066

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1802

---

What are the differences between oltp and olap?

1018

---

What are the types of schemas we have in data warehouse and what are the difference between them?

989

---

Differentiate between reusable transformation and mapplet.

1144

---

Why update strategy and union transformations are active?

1098

---

What is meant by target load plan?

1031

---

How to join three sources using joiner?

1197

---