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
- 2202 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between SAS Data step and SAS PROC SQL, and which is better?
What is the difference between one to one merge and match merge? Give an example.
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
what is fact table and factless table?
How to create a permanent sas data set?
What system options would you use to help debug a macro? : sas-macro
How would you identify a macro variable? : sas-macro
How do you write a test plan?
Which are the statements whose placement in the data step is critical?
What is the role of administrative users? : sas-grid-administration
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
SAS using companies in chennai
Teradata 
