Star Transformation - 10g

From: A Ebadi <ebadi01_at_yahoo.com>
Date: Tue, 4 Dec 2007 15:51:19 -0800 (PST)
Message-ID: <754500.20785.qm@web51112.mail.re2.yahoo.com>

Does anyone have an example script that creates sample fact/dimension tables and the appropriate fk relationships, bitmap indexes, etc to get a star transformation join to work in Oracle 10g?    

  Environment: Oracle 10.2.0.3.0 on Solaris 10.    

  We've been trying to get it working, but the optimizer doesn't pick this join method. An example would be great if anyone has it.    

  Thanks,
  Abdul        

---

Get easy, one-click access to your favorites. Make Yahoo! your homepage.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 04 2007 - 17:51:19 CST