Forum Discussion

arock-well's avatar
arock-well
Icon for Responsive Resident rankResponsive Resident
2 years ago

Merging Queries: Dataflows vs Datasets?

I realize that normalized star/snowflake schemas are usually the best way to go in terms of efficiency and performance. However, I have a situation where I have six tables (one fact, six dimension) a...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

arock-well first question, why a flat table if you have a proper star schema, you can potentially run into challenges using one flat table, and also it is not the best practice.

  • arock-well's avatar
    arock-well
    Icon for Responsive Resident rankResponsive Resident
    2 years ago

    As I already mentioned in the original message, I realize that is the best way to go. I'm not going to go into the reasons.

     

    So based on that, what would be the best way to do merges: Within a dataflow or dataset?