Fact Table: -- DROP TABLE IF EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW";
CREATE TABLE IF NOT EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW" ( "ZTBR_TransactionCode" integer NOT NULL DEFAULT nextval('system."IMETA_ZTRB_MP$F_ZTBR_TA_BW_ZTBR_TransactionCode_seq"'::regclass), "Company_Code" character varying(4) COLLATE pg_catalog."default", "Posting_Period" character varying(7) COLLATE pg_catalog."default", "Fiscal_Year" character varying(4) COLLATE pg_catalog."default", "Profit_Center" character varying(255) COLLATE pg_catalog."default", "Account_Number" character varying(255) COLLATE pg_catalog."default", "Business_Process" character varying(255) COLLATE pg_catalog."default", "Cost_Center" character varying(10) COLLATE pg_catalog."default", "Internal_Order" character varying(255) COLLATE pg_catalog."default", "Trading_Partner" character varying(255) COLLATE pg_catalog."default", "Amount_in_company_code_currency" numeric(17,2), "Company_code_currency" character varying(5) COLLATE pg_catalog."default", "BRACS_FA" character varying(255) COLLATE pg_catalog."default", "Expense_Type" character varying(255) COLLATE pg_catalog."default", "BRACS_ACCT_Key" character varying(255) COLLATE pg_catalog."default", "CC_Direct" character varying(255) COLLATE pg_catalog."default", "Segment_PC" character varying(255) COLLATE pg_catalog."default", "CC_Master_FA" character varying(255) COLLATE pg_catalog."default", "Master_BRACS_Secondary_Key" integer, "Source_Description_Secondary_Key" integer, "Direct_Indirect_Secondary_Key" integer, "Entity_Secondary_Key" integer, "Region_Secondary_Key" integer, "Staging_Secondary_Key" integer NOT NULL DEFAULT nextval('system."IMETA_ZTRB_MP$F_ZTBR_TA_BW_Staging_Secondary_Key_seq"'::regclass), CONSTRAINT "IMETA_ZTRB_MP$F_ZTBR_TA_BW_pkey" PRIMARY KEY ("ZTBR_TransactionCode"), CONSTRAINT "IMETA_ZTRB_MP$F_ZTBR_TA_BW_Direct_Indirect_Secondary_Key_key" UNIQUE ("Direct_Indirect_Secondary_Key"), CONSTRAINT "IMETA_ZTRB_MP$F_ZTBR_TA_BW_Entity_Secondary_Key_key" UNIQUE ("Entity_Secondary_Key"), CONSTRAINT "IMETA_ZTRB_MP$F_ZTBR_TA_BW_Master_BRACS_Secondary_Key_key" UNIQUE ("Master_BRACS_Secondary_Key"), CONSTRAINT "IMETA_ZTRB_MP$F_ZTBR_TA_BW_Region_Secondary_Key_key" UNIQUE ("Region_Secondary_Key"), CONSTRAINT "IMETA_ZTRB_MP$F_ZTBR_TA_BW_Source_Description_Secondary_Key_key" UNIQUE ("Source_Description_Secondary_Key"), CONSTRAINT "IMETA_ZTRB_MP$F_ZTBR_TA_BW_Staging_Secondary_Key_key" UNIQUE ("Staging_Secondary_Key") )and Dimension:CREATE TABLE IF NOT EXISTS dim."IMETA_Region_Mapping" ( "CoCd" character varying(255) COLLATE pg_catalog."default", "Sub Region" character varying(255) COLLATE pg_catalog."default", "Region" character varying(255) COLLATE pg_catalog."default", "BRACS Entity" character varying(255) COLLATE pg_catalog."default", "Consul" character varying(255) COLLATE pg_catalog."default", "Report" character varying(255) COLLATE pg_catalog."default", "Region BRACS" character varying(255) COLLATE pg_catalog."default", "Group" character varying(255) COLLATE pg_catalog."default", "Group BRACS" character varying(255) COLLATE pg_catalog."default", "J" character varying(255) COLLATE pg_catalog."default", "K" character varying(255) COLLATE pg_catalog."default", "L" character varying(255) COLLATE pg_catalog."default", "M" character varying(255) COLLATE pg_catalog."default", "N" character varying(255) COLLATE pg_catalog."default", "Region_Primary_Key" integer NOT NULL DEFAULT nextval('dim."IMETA_Region_Mapping_Region_Secondary_Key_seq"'::regclass), CONSTRAINT "IMETA_Region_Mapping_pkey" PRIMARY KEY ("Region_Primary_Key") ) How do i get that all these columns that are joined are aligned, meaning if it starts with 1 in one column it must be 1 in the other columns. Or how would you assign unique keys in Postgres?