Conditional Lookup

travis · Post by **travis** » 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.

kcbland · Post by **kcbland** » Wed Jan 21, 2004 1:20 pm

Here's one technique:

viewtopic.php?p=94693#94693

kcbland · Post by **kcbland** » Wed Jan 21, 2004 1:21 pm

Here's some discussion/technique:

viewtopic.php?p=94693#94693

viewtopic.php?t=86234