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
- 2198 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what are input dataset and output dataset options? : Sas programming
is there any differnce between proc means and proc summary?
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
what other SAS features do you use for error trapping and data validation?
How do you add a prefix to some or all variables in a dataset using a SAS macro?
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
describe about metadata object? : Sas-di
What are the Aggregate functions in SQL ?
What is the difference between nodupkey and nodup options?
Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?
what is the Population you used in your project, is it ITT or PP?
0 Answers Accenture, Quintiles,
what is the difference between %put and symbolgen?
Teradata 
