I’m reasonably fresh to DV but have now built a PoC DV based on dbtvault (thanks guys) and I’m now learning the joys of extracting data from the vault. The joins are getting quite extensive. I have one query (loosely based on previous non-DV query) that is up to 25 joins.
My question is, do I need to actually join to a hub if I have the key from one link to drive into the next link in the chain. I can’t see why this would be an issue but I seem to remember reading always go hub → link → hub (repeat) but no specifics were provided for why. For my scenario I have many links that contain the hub key needed for the next link and I don’t need anything from the intermediate hub (or any of it’s satellites). Is there any material reason I shouldn’t go hub->link->link->hub?