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
- 2156 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
SAS using companies in chennai
what is in stream data in SAS?
SAS System ?
How experienced are you with customized reporting and use of Data _Null_ features?
Explain what is SAS informats?
Mention few ways with which a “table lookup’ is done in sas programming.
diff between nodup rec and ondup key???
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?
how can you put a "trace" in your program? : Sas programming
what does .. meant in sas macros
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
Teradata 
