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.

0 Answers  

---

What has been your most common programming mistake?

4 Answers   Wipro,

---

Can you suggest us materials for sdtm mapping?

0 Answers   TCS,

---

Tell e how how dealt with..

0 Answers  

---

Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 Answers  

---

what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,

---

Describe the ways in which you can create macro variables? : sas-macro

0 Answers  

---

how can you import .csv file in to sas? : Sas programming

0 Answers  

---

Difference between sum function and using “+” operator?

0 Answers  

---

what is SAS/Graph?

1 Answers   CitiGroup, NTPC,

---

What is the difference Using & and && in the macro variables

5 Answers   Accenture,

---

sas implimented companies in hyderabad

11 Answers   CTS, HSBC,

---