Conditional Lookup
Moderators: chulett, rschirm, roy
Conditional Lookup
I have a initial conversion related situation. I have to join fact information to a dimension based on matching the fact effective date with the dim record having the max effective date <= the fact effective date. There are two other PKs along with the date that create the link between the fact & dim. Any suggestions? Thanks.