Data Warehouse Concepts

            1. DSS (Decision Supporting System).
            2. OLTP System.
            3. OLAP System.
            4. Data Warehouse Architecture.
            5. ETL Flow of Data Warehouse.
            6. BI Flow of Data Warehouse.
            7. Dimension Tables.
            8. Fact Tables.
            9. Dimensional Modeling.
            10. Star Schema.
            11. Snow Flake Schema.
            12. Hybrid Schema.
           
            Data Stage

        1. Architecture Of Data stage Server Jobs.
           2. Architecture Of Data stage Parallel Jobs.
           3. Difference between Server Jobs and Parallel Jobs.
           4. OSH (Orchestrate)
           5. Configuration File.
           6. Data stage Server Components.
                       Data stage Server.
                       Data stage Repository.
                       Data stage Packed Installer.

            7. Data stage Client Components   

                             Data stage Administrator.
                       Data stage Designer.
                       Data stage Director.
                       Data stage Manager.
           
            8. Stages in Data stage

                                Oracle Enterprise.
                        Sequential File.
                        Data set.
                        Transformer.
                        Lookup.
                        Joiner.
                        Merge, Sort, Funnel, Copy, Filter.
                        Remove Duplicate Stage.
                        Modify Stage.
                        CDC
                        Storage Key Generator.

           9. Changing Dimension Implementation in Parallel Jobs.
            10. Reject Handling.
            11. Null Handling.
            12. Organization Flow.
            13. Project Flow.
            14. Testing Process.
            15. Development.                                       Top