I wasn't aware of that Oracle had bulkload facility for updates. Even so, I don't think that SAS DI Studio can use that out of the box.
For inserts, bulkload can definitely be used. See BULKLOAD and the BL family options.
For the update part, it depends on how many rows that need to be updated. There is no solution that works best for alla cases, so you might do some testing.
From the top of my head I think the the SCD Type 2 Loader have an option to upload records for update. There is also the DBKEY option. So a general advice is first find the optimal way of doing this, and then find the best way to fit it into DI Studio.
Data never sleeps