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

Post New Answer

More SAS Interview Questions

what is Enterprise Guide?what is the use of it?

2 Answers   CitiGroup, Oracle,


Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?

3 Answers  


What is the difference between nodupkey and nodup options?

0 Answers  


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.

1 Answers  


How does proc sql work?

0 Answers  






What are the default statistics for means procedure?

0 Answers  


How to get the repeated values by using sql in sas ?

2 Answers  


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.

2 Answers   Accenture,


how to generate report for 0 observation dataset?

3 Answers   Mind Tree, Student,


If a variable contains only numbers, can it be a character data type?

0 Answers  


If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?

8 Answers   HCL,


How to read multiple excel sheets from a single excel file at once????

7 Answers   HCL, Verinon Technology Solutions,


Categories