How to Join Two ODSs

19 Views

Dear All,

I have Two ODSs .

ODS1 is for Customer related Transaction records and

ODS2 is for Customer Agreement which contains Customer rate card with time validity.

ODS1 Records -

<b>Customer material Hitdate Quantity

C1 M1 20051015 5</b>

ODS2 Records -

<b>Customer material rate validfrom validto

C1 M1 10 20051001 20051031

C1 M1 20 20051101 20051130</b>

On Infoset Query where ODS1 and ODS2 (Joins on Customer and Material) shows for every transaction two records from ODS2.

Please guide me How can I restrict the time validity of ODS2 on HitDate of ODS1.

In above given eg.

Only one record should come as Query outout because ODS1-HITDATE lie in ODS2-validity interval of October

which is

Customer masterial Hitdate rate quantity

C1 M1 20051015 10 5

At Infost level if I join ODS1-Hidate with ODS2-Validfrom then Query doesnot show any value becuse it looks for Value match where it finds Hitdate value is not equal to Validfrom value.

waiting for solution

Vishal