Kimbal Fact Table Type - Transactional Type Issue

  • Lynn,

    Again... I know that If I use this aggregate table I'll lose some detail information that your refer! I told you from the begining that I can have a requirement to get just sales amount by customer and by date!.. why? To make a huge redution of the fact table... The data volume can be a constraint and also I can imagine a scenario with both detail (line item) and agregate (transaction) for performance reasons.

    I know perfectly that all your questions are very important!!

    Regards and thanks!

    Pedro

  • Unfortunately, none of your responses until now really made that clear. I apologize if I got to aggressive in trying to make that point.

  • No problem Lynn! Your feedback was very important for me! Thanks for that!!

    Regards,

    Pedro

Viewing 3 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply