Hi Bala,
Could you indicate which files are you referring in this scene? They could be the aggregations and other data to be updated in the cube.
As for the composite key in OLAP cube, I think in data aggregation perspective ( which is the center function of SSAS ), the composite key and one primary key should performance much the same. (I didnot find doc on this, it is my own opinion) . Others that could be taken into consideration is much like normal relational database. You could check this : What are the pros and cons of using multi column primary keys?
Regards,
Lukas
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.