Skip to Content
0
Apr 04, 2011 at 02:10 PM

Infoset joins issue

13 Views

There are 2 ODSs.

Orders ODS and Revenue ODS.

I have in Orders ODS the fields as

Doc No.     Material    Item Category         Revenue
65237        4415         IO18                  0
65237        4418         IO19                  0
65237        6789         IU01                  2000
65456        4415         IO18                  0
65456        4418         IU01                  6000
65456        6789         IU08                  4000

In Revenue ODS the fields are

Material    Item Category       Revenue  
6789         IU01                  2000
4418         IU01                  6000
6789         IU08                  4000

What should be the joins taken between the 2 ODS?

How should the relations be made?