I have loaded in two tables (and done some aggregations with both of them) and now I would like to outer join these two tables.
My first table:
RECEIVABLES3: NoConcatenate Load DIMENSION04, AMT Resident RECEIVABLES2; DROP table RECEIVABLES2;
BROKER_D: Noconcatenate Load DIMENSION04, AMT_br resident BROKER_C; drop table BROKER_C;
I would like to join these tables. As a result I would like to have one table, which has three columns: DIMENSION04, AMT and AMT_br. AMT and AMT_br are columns with numerical values, DIMENSION04 is an unique characteristic. Some DIMENSION04 values could be present in both tables. In final table I want to have all DIMENSION04 values and corresponding AMT and AMT_br values.