You can. But simply loading them might not give you a perfect model, that might seek for some modifications to that simplicity(again that depends on your tables)
Yes, in a broad sense. However, the term fact table is more appropriate when we talk about date modelling, whereas, transactional table is in raw database.
You can. But simply loading them might not give you a perfect model, that might seek for some modifications to that simplicity(again that depends on your tables)
Fact Table is nothing but the transaction table like Sales, Orders tables etc it has the core fields and some ID fields which qualifies the transactions like Customer, Salesman, Branch, Region etc.
Where Master tables are those which has the details of Customers, Salesman, Branch etc.
The Fact table is surrounded by the Master/Dimension tables.
