i'm trying to link and concatenate different tables to create master calender for oracle data source and end up with "Table Not Found" error from LinkTable_Temp (show bellow).
LinkTable_Temp:
//LOAD
SQL
SELECT *,
DateTIme AS DATE,
'GATEWAYDATE' AS DateType
FROM
"SAEGW"."GTP_STATS"
WHERE
DATETIME >= SYSDATE - 7 AND SUBSTR(PDNGW,11,3) in ('P01', 'P02', 'P03');
PCRF_STATS: ---- TABLE NOT FOUND ERROR
Concatenate(LinkTable_Temp)
SQL
SELECT
*,
DATETIME AS DATE,
'PCRFSTATSDATE' AS DateType
FROM
"CRF"."ERTICAL_15M"
WHERE
DATETIME >= SYSDATE - 7 AND CATEGORY = 'PC'
GROUP BY
PCRF, DATETIME, "COMPONENT_NAME", "PROCESS_NAME"
;
DB_SESSION_COUNT: ---- TABLE NOT FOUND ERROR
Concatenate(LinkTable_Temp)
SQL
SELECT
*,
DATETIME AS DATE,
'DBDATE' AS DateType
FROM "CRF"."ALLSESSIONCOUNT_DY" A, "CRF"."STALESESSIONCOUNT_DY" B
WHERE TO_CHAR(B.DATETIMEZONE, 'MM/DD/YYYY HH24:MI') = TO_CHAR(A.DATETIMEZONE, 'MM/DD/YYYY HH24:MI')
AND A."EMS_NAME" IN ('10_36_66_136', '10_37_19_136', '10_37_166_136','107_246_96_136','155_174_220_136','10_40_16_136','107_246_112_136')
AND A.DATETIME >= SYSDATE - 7;
LinkTable:
LOAD
DATE,
DateType,
PDNGW &'-'& DATETIME AS "KEY_PDP_COUNT",
PCRF &'-'& DATETIME AS "KEY_PCRF_STATS",
"CRF"."ALLSESSIONCOUNT_DY"."EMS_NAME" &'-'& "CRF"."ALLSESSIONCOUNT_DY".DATETIME AS "KEY_DB_SESSION_COUNT"
RESIDENT LinkTable_Temp;
DROP Table LinkTable_Temp;
