1 of 1 people found this helpful
Off the top of my head:
- Secondary data sources must be aggregated and therefore can't be sorted on
- Secondary data sources can break COUNTD() functions depending on the 3 things Jonathan talked about yesterday
- Secondary data sources can introduce a complexity that slooooows performance in certain cases
I'll stop here, because I am currently extremely frustrated with secondary data sources and don't want to malign them beyond their due.
Thanks Shawn! That's the kind of info I'm looking for.
In thinking about this a little more it seems the cons of having a joined table in this example are that one needs to be careful in the policy counts (using CNTD) which impacts performance and also premium amount aggregations since some policies are now repeated for the claims. Perhaps there are standard ways of calculating this. Maybe there is no one right answer of which data modeling method to choose.
And can someone please explain the rational why there is no attachment icon in these reply screens? Maybe I need to go to original post? It seems I can insert anything but a workbook here. Thanks.