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
- 2160 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantages of using sas?
what is sas and what are the functions? : Sas-administrator
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Explain the use of proc gplot? : sas-grid-administration
In PROC PRINT, can you print only variables that begin with the letter “A”?
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
How do you specify the number of iterations and specific condition within a single do loop?
Which date function advances a date, time or datetime value by a given interval?
Explain substr function?
What are the data types that sas contain?
What are the 3 components in sas programming?
i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
Teradata 
