My source is single table from a database having multiple columns with millions of records, data will be increase on weekly basis.
can anyone please suggest me the best data model to handle this data, is it fine to split the table and create linked table, will this approach be correct??
If you don't have key fields then don't split the table maintain it in a single table.
For example:
If you have
CountryID, Country, Date, Sales then split Country dimension table, if your data not in this format then do it with a single table. Don't complicate the model.
yes I am splitting the one with key fields remaining I am maintaining in same table...suggest me which one is suited for this scenario autokey or rownumber??
