ORACLE sql HELP NEEDED [message #661399] |
Thu, 16 March 2017 12:03 |
|
abhi2varmaarma
Messages: 1 Registered: March 2017
|
Junior Member |
|
|
hi guys can some 1 help me with the sql for the below scenario
Table 1
Fact Table
3/16/2017 10 20 30 3/16/2017 01:30-02:00
Table 2
Dim Table
Date Time
3/16/2017 3/16/2017 00:00-00:30
3/16/2017 3/16/2017 00:30-01:00
. .
. .
. .
. .
. .
. .
. .
3/16/2017 3/16/2017 23:00-23:30
3/16/2017 3/16/2017 23:30-00:00
Desired Output
3/16/2017 00:00-00:30 Null Null Null
3/16/2017 00:30-01:00 Null Null Null
. Null Null Null
. Null Null Null
. Null Null Null
3/16/2017 01:30-02:00 10 20 30
. Null Null Null
. Null Null Null
. Null Null Null
3/16/2017 23:00-23:30 Null Null Null
3/16/2017 23:30-00:00 Null Null Null
|
|
|
|
|