Unknown Inferred member....
-
Hi...
I have a requirement to work on early arriving facts, like if I get an employeeID that is not yet present in employee dimension, they want me to generate a surrogate key in the employee dimension and put that early arriving empUID in the dimension with other columns as UNKNOWN...(that will be updated in later runs)...
I have no idea how to do this...?
Any help on inferred memeber generation and on how to handle early arriving fact??
Thanx in Advance.
[font="Comic Sans MS"]
---------------------------------------------------Thanks [/font]
-
You have to insert the early arrived EmployeeID in the employee dimension and get the generated (surrogate) id and use it in the fact table. Check this post for efficient way ro retrieve the id.
After you receive your new employee information, you have to either update the existing employee record (look for EmployeeID) or insert a new employee record.
That's it. Very simple.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
I thought I had read a technical paper on the Microsoft MSDN site about this before, but I can't seem to find it now. I did find a link to something that may be helpful:
http://www.rkimball.com/html/designtipsPDF/KimballDT57EarlyArriving.pdf
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply