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
- 2161 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is data access? : Sas-di
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
how can you code the confidence intervals?
6 Answers Cytel, IIT, Ranbaxy,
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
How to write duplicate records into a separate dataset using sort?
what is a post baseline?
what is the use of catalog?
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
What is data _null_?
Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?
What is a post baseline?
Teradata 
