If your ultimate destination is east coast, you'll go to BDOC in Norfolk, west coast/7th fleet in San Diego.
Whatever makes the most sense. If you're going to be stationed in the US, you'll almost certainly go to your ultimate command first for TAD. I graduated OCS mid October and just now got in to BDOC, so unless you're super duper special you're gonna be waiting to class up for a bit. I know people from my OCS class whose ultimate is Yokosuka that were stashed in San Diego the entire time. That is, from October 16th until last Monday when our BDOC class convened, never having been to their ships. However, there is a guy in our class who went to Yokosuka for 6 months before classing up, and he said he is about 80% of the way to getting pinned already. YMMV, like most things in the Navy it seems.
I am stationed in San Diego and started BDOC this past Monday. I went to my ship TAD and was obviously able to start housing allowance and settle here. As I said, my cohorts that will be in Japan had very different experiences. The ones I know who went to Pearl Harbor also went to Hawaii first TAD.
Actual training pipeline for a regular old SWO 1160 is BDOC then ultimate duty station. Even then it can be different. For example, me. They're making me A-COMMO. The idea is that all small boys will divide CC division in to two DIVOS, one of which will be in charge of COMMs (the COMMO) and the A-COMMO overseeing network security. So I have another intermediate stop for a school at Corey Station before heading back to my ship. I will remain 1160 SWO but go to the same school that a SWO-IP would attend. I may try to lateral transfer after getting pinned because IP seems like it would be a sweet gig.
From what I understand, COMMO is trending towards a second tour job with a SWO-IP option as the preferred pick to fill the role.