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.
No Answer is Posted For this Question
Be the First to Post Answer
what is Enterprise Guide?what is the use of it?
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
What is the difference between nodupkey and nodup options?
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
How does proc sql work?
What are the default statistics for means procedure?
How to get the repeated values by using sql in sas ?
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
how to generate report for 0 observation dataset?
If a variable contains only numbers, can it be a character data type?
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
How to read multiple excel sheets from a single excel file at once????
7 Answers HCL, Verinon Technology Solutions,