Loading ...
Sorry, an error occurred while loading the content.
 

Re: [OracleWarehouseBuilder] Digest Number 334

Expand Messages
  • Sachin Garg
    You basically designate a table as a fact or dimension in Oracle. Describing/querying a dimension is same as doing the same for a table. There is 1 message in
    Message 1 of 1 , May 31, 2006
      You basically designate a table as a fact or dimension in Oracle. Describing/querying a dimension is same as doing the same for a table.


      There is 1 message in this issue.

      Topics in this digest:

      1. Quick question about dimension
      From: "OWB Kid" owb_kid@...

      ________________________________________________________________________
      ________________________________________________________________________

      Message: 1
      Date: Tue May 30, 2006 9:23 pm (PDT)
      From: "OWB Kid" owb_kid@...
      Subject: Quick question about dimension


      Hi all

      I am just wondering how to see the contents of a
      dimension in SQL PLUS

      a) describe a dimension (to see the columns etc)
      b) display data from a dimension (select * from ....)


      Thanks

      OWB Kid




      ____________________________________________________
      On Yahoo!7
      Dating: It's free to join and check out our great singles!
      http://www.yahoo7.com.au/personals


      ________________________________________________________________________
      ________________________________________________________________________

      Join
      http://www.smartgroups.com/groups/Datawarehouse

      ------------------------------------------------------------------------
      Yahoo! Groups Links




      ------------------------------------------------------------------------






      __________________________________________________
      Do You Yahoo!?
      Tired of spam? Yahoo! Mail has the best spam protection around
      http://mail.yahoo.com

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.