4 Replies Latest reply: Apr 11, 2012 6:26 AM by Ankit Khandelwal RSS

    Need Help.

    Nagaraja Akkivalli
      Hi All,


      Can you please share the link to design the Ware House using Oracle Ware House Builder. Please also post the best practices. I welcome your suggestions.

      Thanks and Regards
      Nagaraja Akkivalli.
        • 1. Re: Need Help.
          MccM
          Data warehouse is not something you should look at from OWB view. It's concept is bussiness and data driven while OWB is nothing but a tool.


          http://webdocs.cs.ualberta.ca/~zaiane/courses/cmput605/2008/pdf/sen_sinha.pdf

          http://en.wikipedia.org/wiki/Oracle_Unified_Method

          http://docs.oracle.com/cd/B10501_01/server.920/a96520/concept.htm

          http://www.1keydata.com/datawarehousing/processes.html

          http://www.kimballgroup.com/html/designtips.html

          http://www.horsburgh.com/h_dataw.html
          • 2. Re: Need Help.
            Ankit Khandelwal
            Start a Mapping or Process flow from OWB.
            http://prsync.com/oracle/start-a-mapping-or-process-flow-from-owb-browser-22468/

            Oracle® Warehouse Builder Data Modeling, ETL, and Data Quality Guide 11g Release 2 (11.2)
            http://oracle.su/docs/11g/owb.112/e10935/activities_in_pf.htm

            Automating ETL using OWB
            http://www.databasejournal.com/features/oracle/article.php/2241331/Automating-ETL-using-Oracle-warehouse-Builder---Part-2-OWB-architecture.htm

            Debugging and Diagnostic in OWB
            http://docs.oracle.com/html/B11000_02/apddiagn.htm

            OWB 10g Architecture White Paper
            http://www.dwlogic.com/community/articles/Oracle10g_DW_Architecture.pdf

            Pluggable Mappings using OWB
            http://www.rittmanmead.com/2006/07/pluggable-mappings-using-owb10gr2-2/

            Oracle® Warehouse Builder API and Scripting Reference 10g Release 2 (10.2)
            http://docs.oracle.com/cd/B31080_01/doc/owb.102/b28225/api_3designviews.htm

            Oracle® Warehouse Builder User's Guide 10g Release 2 (10.2.0.2)
            http://docs.oracle.com/cd/B31080_01/doc/owb.102/b28223/ref_processflows.htm
            • 3. Re: Need Help.
              Nagaraja Akkivalli
              Sorry for misquoting the question.

              Can you please share the link to "implement" the Ware House using Oracle Ware House Builder.

              Here we are...

              We have identified all dimensions and designed the dimensional tables. Designed the summary tables which stores the user's aggregated data. Imported all dimensional and fact table using design Center.

              What next ? I mean

              How will populate the fact and dimensional tables table from transactional table using OWB ?
              How I need to automate the table loads using jobs ?

              Please let me ow if you need any details.

              Thanks and Regards
              Nagaraja Akkivalli.
              • 4. Re: Need Help.
                Ankit Khandelwal
                Hi Nagaraja,

                First Step is to import all the tables, views, proceudres, functions and other DB obects in OWB Designer. After this, using existing transformation available OOB in Designer, mappings can be created to achieve desired functionality.

                Below link describes basics of designing mapping in OWB.
                http://docs.oracle.com/cd/B28359_01/owb.111/b31278/concept_basics.htm

                Below link shows scheduler configuration & settings.
                http://docs.oracle.com/cd/B28359_01/owb.111/b31278/ref_schedule.htm#WBDOD11700

                Please note that appropriate synonyms, priveleges and DB links must be created before hand in DB to run the mapping.

                Warm Regards,
                Ankit Khandelwal

                Edited by: Ankit Khandelwal on Apr 11, 2012 4:25 AM