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
- 1687 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
If a variable contains letters or special characters, can it be numeric data type?
what is the difference between proc means and proc tabulate?
explain the concepts and capabilities of business object? : Sas-bi
% let A=3+4 what is result
Mention what is the difference between nodupkey and nodup options?
How can you create a macro variable with in data step? : sas-macro
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
what techniques and/or procs do you use for tables? : Sas programming
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE
What is the difference Using & and && in the macro variables
How would you determine the number of missing or nonmissing values in computations?
What is PROC in SAS?
Teradata 
