Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 11194 invoked from network); 4 Dec 2007 18:38:24 -0600
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 4 Dec 2007 18:38:24 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D3B517D19B0;
 Tue,  4 Dec 2007 19:38:24 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 10953-01; Tue, 4 Dec 2007 19:38:24 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 402237D198E;
 Tue,  4 Dec 2007 19:38:24 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 04 Dec 2007 18:51:28 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 715BB7D057C
 for <oracle-l@freelists.org>; Tue,  4 Dec 2007 18:51:28 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 03450-07 for <oracle-l@freelists.org>;
 Tue, 4 Dec 2007 18:51:28 -0500 (EST)
Received: from web51112.mail.re2.yahoo.com (web51112.mail.re2.yahoo.com [206.190.39.89])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id C04757D0DF2
 for <oracle-l@freelists.org>; Tue,  4 Dec 2007 18:51:24 -0500 (EST)
Received: (qmail 20940 invoked by uid 60001); 4 Dec 2007 23:51:19 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=gXfYohQYD1v8I03Pf+GclxfDMxgGH7lXGJAKQHGj5Ks3ThjofCCHbN7Tzc29Kk8IuAXJNePGa+xxJZ3c7w+yLA7knriFES77c0c6/iTDtpJf6HGXyek2STmZOOJf57C6xrOje7117DKAew25r+T8Lz0zmVtfiH1nNDuPayiOIPg=;
X-YMail-OSG: 1YhvCd4VM1lB0LAZhZTziQWMQTsA.T6SXXZeYNTYLZJfeJ4eE.AngLMnVeGZ9nIVnoF9hnIMY3ysdxBVGeyeZ_0FBsadVKZAclpv2LmmJJnxs1J1YKY-
Received: from [209.244.4.106] by web51112.mail.re2.yahoo.com via HTTP; Tue, 04 Dec 2007 15:51:19 PST
Date: Tue, 4 Dec 2007 15:51:19 -0800 (PST)
From: A Ebadi <ebadi01@yahoo.com>
Subject: Star Transformation - 10g
To: oracle-l@freelists.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1783718941-1196812279=:20785"
Message-ID: <754500.20785.qm@web51112.mail.re2.yahoo.com>
X-archive-position: 3704
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: ebadi01@yahoo.com
Precedence: normal
Reply-to: ebadi01@yahoo.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain
--0-1783718941-1196812279=:20785
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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.
--0-1783718941-1196812279=:20785
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>Does anyone have an example script that creates sample fact/dimension tables and the appropriate fk relationships, bitmap indexes, etc&nbsp;to get a star transformation join to work in Oracle 10g?</div>  <div>&nbsp;</div>  <div>Environment: Oracle 10.2.0.3.0 on Solaris 10.</div>  <div>&nbsp;</div>  <div>We've been trying to get it working, but the&nbsp;optimizer doesn't&nbsp;pick this&nbsp;join method.&nbsp; &nbsp;An example would be great if anyone has it.</div>  <div>&nbsp;</div>  <div>Thanks,</div>  <div>Abdul</div><p>&#32;
      <hr size=1>Get easy, one-click access to your favorites. 
<a href="http://us.rd.yahoo.com/evt=51443/*http://www.yahoo.com/r/hs"> Make Yahoo! your homepage.</a>


--0-1783718941-1196812279=:20785--
--
http://www.freelists.org/webpage/oracle-l