Home Services FCS Education Data Warehouse Administration Console
Course ID 307: Oracle BI Apps - Data Warehouse Administration Console (DAC)
Course Details Day 1

Session 1:
  • Overview of Extract Transform and Load
  • OBIA Informatica Architecture
  • Install and Configure the Informatica
  • OBIA Informatica Components
  • Understand Building Mappings

Session 2:
  • Create and Execute Workflows
  • Troubleshoot and Monitor Workflows
  • Understand Different Transformations
Course Details Day 2

Session 3:
  • Extraction, Transformation and Load process used to load the OBAW
  • Identifying Tables, Tasks and Mapping Used to support ETL Process
  • Source Dependent Extract (SDE) and Source Independent Extract(SIL)
  • Exploring Out of box Mappings
  • Post Load Process(PLP)

Session 4:
  • Install the Data Warehouse Administration Console (DAC)
  • Install and configure the OBAW
   
Course Details Day 3

Session 5:
  • Explore DAC objects, tasks, subject areas, Execution Plans
  • Customizing DAC Metadata
  • Create a New Custom Container
  • Create a Custom Execution Plan
  • Schedule and Run the Execution Plan

Session 6:
  • Troubleshooting Load process
  • Overview of Customizations to the OBAW

 

For more details contact FCS_INFO@teksystems.com