@jagalindo Please don't use combination of properties as it adds unnecessary overhead to the process. The list can be numbered or not, that doesn't matter because you shouldn't be using properties on that list and using combination of properties requires you do use properties. Please read this article which explains exactly why and how you should load your data. Data Hubs: Purpose and Peak Performance The concatenation of ten properties is fine, in fact that is what you are supposed to do. Just be careful to use the codes of those attributes/properties because you have limited space available (60 characters). This will be your transactional list. Now, create two modules: Transactional data which will be dimensionalized by the transactional list and Time. This is where your transactional data (Net Sales) gets loaded to. The second module will be your Attribute or Properties module where you will, by using formulas, decipher the attributes from the code. That will get your data loaded to the hub correctly. Now, since your are doing an incremental load from the source, which is PERFECT, now you need to figure out which records/data have been loaded so you only load that data (the data that has changed) to your spoke model. Please watch this video. Delta Loading Rob
... View more