ODI 12C and OBIA 11G Course:
Chapter 1 | Data Warehouse Concepts |
Chapter 2 | Introduction to Oracle Data Integrator |
Chapter 3 | ODI 12c Installation and Architecture |
Chapter 4 | Hand on 1: Creating Master and Work Repository (Method 1) |
Chapter 5 | Hand on 2: Creating Master and Work Repository (Method 2) |
Chapter 6 | Configuring RRITEC Database |
Chapter 7 | Creating and Managing Topology |
Chapter 8 | Creating Model |
Chapter 9 | Creating Project |
Chapter 10 | Markers |
Chapter 11 | Calculations/ Expressions |
Chapter 12 | Hands On 9: Create a Mapping Using Flat File to Filter |
Chapter 13 | Hands on 10: Create a Mapping using MTI (11g/Split 12C) |
Chapter 14 | Create a Mapping using Joiner |
Chapter 15 | Creating A Mapping using Lookup |
Chapter 16 | Creating a Mapping using Sort |
Chapter 17 | Create a Mapping using Aggregate |
Chapter 18 | Create a Mapping using Distinct |
Chapter 19 | Creating a Mapping using Set Component |
Chapter 20 | User Function |
Chapter 21 | Variables |
Chapter 22 | Sequences |
Chapter 23 | Procedures |
Chapter 24 | Packages |
Chapter 25 | Scenarios |
Chapter 26 | Load Plan |
Chapter 27 | Agents |
Chapter 28 | Version Control and Solutions |
Chapter 29 | Modifying Knowledge Module |
Chapter 30 | Change Data Capture(CDC) |
Chapter 31 | Deployment or Migration (Exporting and Importing) |
Chapter 32 | Security |
Chapter 33 | CKM |
Chapter 34 | Slowly Changing Dimension (SCD 1 & SCD 2) |
Chapter 35 | Temp / Yellow Interface |
Chapter 36 | Shortcut |
Chapter 37 | Release Tags |
Chapter 38 | Performance Tuning in ODI |
OBIA 11G | |
Chapter 39 | Introduction |
Chapter 40 | OBIA 11G Architecture |
Chapter 41 | OBIA 11G Installation & Configuration |
Chapter 42 | Configuration Manager (BIACM) |
Chapter 43 | Functional Setup Manager |
Chapter 44 | Manage Load Plans |
Chapter 45 | Monitoring Load Plans |
Chapter 46 | Trimming RPD |
Chapter 47 | Loading RPD into OBIS |
Chapter 48 | Loading Catalogue into BIPS |
Chapter 49 | Understanding HR Analytics |
Chapter 50 | Understanding Finance Analytics |
Chapter 51 | Cabout Configuring accounts file |
Chapter 52 | OBAW Customization Overview |
Chapter 1 | Informatica Introduction |
Chapter 2 | Informatica 9 Installation |
Chapter 3 | Informatica Administration Console |
Chapter 4 | Repository Manager |
Chapter 5 | Configuring Manager |
Chapter 6 | Configuring Source and Target Database |
Chapter 7 | Hand on 01 Source & Target Import |
Chapter 8 | Hand on 02 Creating Mapping |
Chapter 9 | Hand on 03 : Creating Workflow |
Chapter 10 | Hand on 04: Flat File Filter |
Chapter 11 | Working with Router Transformation |
Chapter 12 | Working with Sorter and Aggregator Transformation |
Chapter 13 | Working with Joiner Transformation |
Chapter 14 | Working with Lookup Transformation |
Chapter 15 | working with Parameters and Variables |
Chapter 16 | working with Sequence Generator Transformation |
Chapter 17 | working with FF to FF,XML,Cobol |
Chapter 18 | working with SCD – Slowly changing Dimensions |
Chapter 19 | Working with Source Qualifier Transformation |
Chapter 20 | working with Union and Stored Procedure Transformation |
Chapter 21 | working with Mapplets and Reusable Transformation |
Chapter 22 | Working with Target Load plan and Tasks |
Chapter 23 | working with Work lets and PMCMD and PMREP |
Chapter 24 | working with Deployment and Security |
Chapter 25 | Working with Creating Dynamic Parameter file in Informatica |
Chapter 26 | working with Informatica XML Source |
Chapter 27 | XML Transformation |