Vertica Dimension Table query
I need support/help in the below query.
"my application is using the vertica and i have one datamart table. and this table is refering to the dimension tables now the issue is i have created one dimension table for column which is in datamart table, my definition for the dim table is like below.
CREATE TABLE DIM_AffectedService (
) ORDER BY Affected_Service UNSEGMENTED ALL NODES;
ALTER TABLE DIM_AffectedService ALTER COLUMN Affected_Service SET NOT NULL;
ALTER TABLE DIM_AffectedService ADD CONSTRAINT DIM_Affected_Service_PK_ID PRIMARY KEY (Affected_Service);
ALTER TABLE FCT_FAULT ADD CONSTRAINT FF_FK_NE_TYPE FOREIGN KEY (Affected_Service) REFERENCES DIM_AffectedService (Affected_Service);
GRANT ALL ON DIM_AffectedService TO ossa;
FCT_FAULT is the main datamart, now the issue i am facing is i am having the data available for the Affected_Service in FcT_Fault table but i am not able to see any data in the dimension table.