I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2198

---

What the different components of Replication and what is their use?

1125

---

Explain Robotics process automation (rpa) tools and technologies?

1

---

What do you mean by normalize in bootstrap?

1

---

What is action and transformation in spark?

1228

---

Question for mech.engineer in dmrc

1909

---

What is soil science? : soil science

1074

---

Explain the page lifecycle of an asp.net mvc? : asp.net mvc

932

---

Explain when you can use unbinding function in backbone.js ?

5

---

How to write a program of web logic server to get the connection pool attribute?

1001

---

Explain which of the earths interior layers have been drilled and sampled?

806

---

Logic calculations are done in which type of registers?

1436

---

What's Stress Testing?

1195

---

What is dll error in windows?

919

---

Why use update_statistics command in sql server?

1113

---