IntervalMatch is a viable solution but it is memory and cpu intensive. When your data volumes are high you may find that intervalmatch will take a very long time to process. There are a couple of ways to tune the process by doing the interval match manually.
The join can be accomplished using a two step process
Claims:
Load * Inline [
MemberID,TransactionDate,Amount
];
Left Join(Claims)
//Enrollment
Load * Inline [
MemberID,EnrollmentSequence,BeginDate,EndDate,Limit
];
Inner Join(Claims)
Load
MemberID,
TransactionDate,
BeginDate,
EndDate
Resident Claims
Where TransactionDate >= BeginDate and TransactionDate <= EndDate
