Download - Infoset Demo
-
8/3/2019 Infoset Demo
1/14
MATNUM DOCNUM ITEMTYPE SALRY
100001 120001 A 2
100002 120001 B 3
100003 120003 C 4
100004 120004 D 5100002 120001 B 6
100002 120001 B 3
100003 120001 C 4
OUTPUT of DSO1
Scenerio 1:
DSO1
Inner join vs Inner join
-
8/3/2019 Infoset Demo
2/14
Scenerio 2:
Scenerio 3: outer vs innsr join
Scenerio 4:
Inner join vs Outer join
-
8/3/2019 Infoset Demo
3/14
-
8/3/2019 Infoset Demo
4/14
MATNUM DOCNUM ITEMSTATITEMTYPEQUANTITY
100001 120001 DEL A 2
100002 120002 DEL B 3
100003 120003 DEL C 4
100004 120004 PEN D 5100005 120004 PEN B 6
100006 120005 PRO B 3
100007 120004 PRO C 4
OUTPUT of DSO2
DSO2
-
8/3/2019 Infoset Demo
5/14
Outer join Outer Join not
-
8/3/2019 Infoset Demo
6/14
-
8/3/2019 Infoset Demo
7/14
-
8/3/2019 Infoset Demo
8/14
ossible
-
8/3/2019 Infoset Demo
9/14
Scenerio 1:
Scenerio 2:
Scenerio 3: Outer join vs Outer join
Inner join vs Outer join
Inner join vs Inner join
-
8/3/2019 Infoset Demo
10/14
Scenerio 4:
-
8/3/2019 Infoset Demo
11/14
-
8/3/2019 Infoset Demo
12/14
Outer join Outer Join not possibl
-
8/3/2019 Infoset Demo
13/14
-
8/3/2019 Infoset Demo
14/14