• Can you attach your target schema? That is, the dimensions surrounding the fact table you are loading along with the fact table itself?

    Also, think about what actual "events" you are measuring and the core business process(es) surrounding the event. More often than not, the "verbs" of your business represent the facts, and the dimensions represent the "nouns" or the "group bys" of your business.

    More often than not, if you have to "group by" it, it is going into a dimension--a dimension that is usually denormalized. If you have to aggregate it, chances are it is a fact. While there are exceptions and advanced concepts where these rules do not apply, try to uses these rules of thumb when mapping your schema back to your business requirements.