Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to load 3 tables like below. Can you suggest what is the best method to load these tables, do I have to load them independently and join (syncretized keys will come) or do I need to concatenate and load them as one single table?
TABLE A YEAR MONTH REGION PRODUCT DEPARTMENT SALES SALES_QUANTITY
TABLE B YEAR MONTH REGION PRODUCT DEPARTMENT ORDER ORDER_QUANTITY
TABLE C YEAR MONTH REGION PRODUCT DEPARTMENT CUSTOMOER ID CUSTOMER NAME PRESHIMPMENT VOLUME PRESHIMENT_QUANTITY
The best approach is to merge all fact tables together, create a calendar table, and link all dimension (master) tables to the merged fact table.
Best Regards,
Arunesh Kumar
thanks. When you say merge, you are saying to concat the tables, correct?
Yes