Everyone a great god, and I ask how PostgreSQL like Oracle inside define Dimension?

CodePudding user response:

Mainly is to want to make the following statement in a query is to be able to walk partition query:
SELECT *
The FROM DMDB. DM_F_OBQA_SV_EC_D T,
DWDB. DIM_TIME_DAY T1
WHERE T.d ay_id=T1. TB_DAY_ID
AND T1. Day_desc='on October 10, 2017'