I have 2 metrics (2 Facts QVDs) which has different data structure and formats. The DATE fields have different definition though in both QVDs and granularity is different as well.
QVD 2 has: Plant_ID, Month_Year, Supplier_ID, Date_ID, Order Amt, Order Qty, Calendar_ID, KP2.
As a best practice approach, all the Facts to be concatenated into a single table. Looking into my above scenario, could someone please help, Which approach to follow - CONCATENATE (How) or JOIN?
A concatenate load will append the data from table 2 to table 1, combining the common fields. If it finds a field which isn't in both tables, it simply loads as blanks in the respective table. This sounds like what you need, this will create 1 main fact table of the two tables combined.
Joining will add columns to your fact table instead of rows.
.png "Former Employee"){kind=icon}