Explain scd type 3 through mapping.

1023

---

What is dimensional table?

1073

---

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

1591

---

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

1133

---

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.

1178

---

Explain in detail about scd type 1 through mapping.

1564

---

Write the unconnected lookup syntax?

1088

---

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

1118

---

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

1173

---

What is dimensional table? Explain the different dimensions.

1176

---

What are the types of caches in lookup?

1055

---

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

975

---

Differentiate between router and filter transformation?

1019

---

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.

1713

---

What are the differences between oltp and olap?

978

---