According to resources, in Dimensional Warehousing, it is a good idea to place Dimension tables in a different filegroups from Fact Tables. In OLTP, is it a good idea to place Lookup tables in filegroups, from Transactional Tables. OLTP and Datawarehousing are different. (As Lookup tables are different from Dimensional Tables, Relational vs Kimball). Just wanted confirm this idea?
• "Put different tables used in the same join queries in different filegroups. This will improve performance, because of parallel disk I/O searching for joined data.
• To maximize performance, create files or filegroups on different available disks as possible. Put objects that compete heavily for space in different filegroups.
• Put heavily accessed tables and the nonclustered indexes that belong to those tables on different filegroups. This will improve performance, because of parallel I/O if the files are located on different physical disks."