I have an issue where we some fact tables all associated around Employee Data. The tables are Actives, Departures, Transfers. The data has data in in that is repeated in each. IE Name, ID, Etc but each table represents different data.
Would the recommended way be to use join or concatenate these all into one table? Should this all be stacked into one fact table or have fields renamed to avoid the synthetic keys? Open to suggestions/questions. Thanks!