Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2104 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how do you read binary data in sas?
describe the interaction table in sas di? : Sas-di
proc means? proc sort? proc append? proc freq? proc print? proc content?
what is washout period?
How do you generate random samples?
What does PROC print, and PROC contents do?
how can you sort the dataset having millions of OBS(instead of sort procedure?
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
how to generate the test data in sas without input data? : Sas-administrator
Why double trailing @@ is used in input statement?
what are validation tools that are used in sas? : Sas-administrator
what is the use of proc sql? : Sas programming
Teradata 
