Conditional Lookup
Posted: Wed Jan 21, 2004 1:06 pm
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.