Human Machine Interface in Control RoomFull description
Protective Coatings and Linings
Descripción completa
Procedimiento Trabajo Seguro en uso de aspiradora industrial, para extraccion de polvo particulado (silice).Descripción completa
This revision of PTS 34.00.01.30 MINIMUM REQUIREMENTS FOR STRUCTURAL DESIGN AND ENGINEERING has been updated to incorporate PETRONAS Lessons Learnt, Best Practice and new information issued by rele...
Oracle Business Intelligence Applications Technical Hands-on Hands-on Workshop Workshop – Day 2
Agen genda – Day 2 Start
End
Agenda Item
8:30
9:00
Breakfast / Questions & Answers (Review Day 1)
9:00
9:30
DAC Execution Review
9:30
10:30
Warehouse Load Confirmation Confirmation Lab – BI EE EE
Review features of the Informatica tool – Informatica Repository Manager – Informatica Designer – Informatica Workflow Manager
•
Duration: 1.0 hour
For more information on Informatica, refer to the Informatica product documentation
Presentation: Oracle Business Analytics Warehouse Customization
OBAW Customization Scenarios •
Categorized by data sources and modification types
Type I Customization Adding Additional Columns •
•
Type I customizations involve extracting additional columns from source systems that are already mapped and loading the data to existing data warehouse tables. Extend mappings –
–
–
Existing mappings and tables are extensible Sample placeholders demonstrate how to pass and store additional data DO NOT modify existing logic or columns
Type I Customization Typical Extension Steps Copy the appropriate mappings to a custom Informatica folder 2. Extend the source and target tables by making changes to the tables in the database 1.
Extend the SDE and SIL mappings by bringing in the additional columns. 4. Copy the appropriate workflows to the custom Informatica folder. 5. Modify the workflows. 3.
6.
Update the DAC with the necessary changes.
Type II Customization Adding Additional Tables •
•
•
•
•
•
Use pre-packaged adaptors to add new fact or dimension tables to the data warehouse, regardless of whether they are already mapped. Build new SDE and SIL mappings. Use required system columns Register tables and indices in DAC Register new tasks for Informatica workflows, assemble subject areas and build execution plans in DAC Use naming convention WC_TABLENAME_
Type II Customization Considerations •
•
•
Create custom SDE and SIL folders in Informatica and make changes to them. Do not change objects in shipped folders Create custom workflows for all customized mappings –
–
–
–
Each workflow should load only one table. Workflow name should match a session name that is used inside the workflow. Set the appropriate source and target connection values in Informatica Designer. Register workflows in the DAC.
Customization Labs Goals of this set of labs: •
•
Allow you to gain high-level working skills with Informatica PowerCenter tools Familiarize you with the steps needed to customize and extend the OBAW in line with Type I customizations
Considerations to keep in mind •
•
•
The Informatica portions will be conducted using a viewlet so you will perform actions inside the viewlet that do not reflect real behavior exactly. These deviations will be noted in the lab steps where appropriate. The end state mapping has already been completed. You cannot make a mistake. Seriously, if you make a mistake the viewlet will not advance (of course you can always advance using the forward button at the bottom of the viewlet).
Use Case •
•
Executives want to see additional data elements related to a customer outreach initiative in the reports that are related to customers. The outreach initiative information is maintained in an Excel spreadsheet by the Director of Customer Satisfaction.
Use Case: Technical Enablement •
In the Oracle E-Business Suite 11.5.10 OLTP Database –
•
In the Data Warehouse: –
–
•
The table LAB_CUST_OUTREACH_ZONES was created to hold the data on customer satisfaction outreach zones and the assignment of current customers to these zones. This data was imported into the database using Oracle Data Integrator.
The table LAB_W_CUSTOMER_LOC_D was created as a copy of W_CUSTOMER_LOC_D with a new column called X_OUTREACH_ZONE added after the X_CUSTOM column. The table LAB_W_CUSTOMER_LOC_DS was created as a copy of W_CUSTOMER_LOC_DS
The source table only has five records since the real point of the exercise is to work with the tools and flow versus loading hundreds of rows of data.
Lab 1 •
Create the mapping and workflow (viewlet)
Lab 2 •
Create the DAC artifacts
Lab 3 •
Run the execution plan and verify load
Lab Exercise: Custom ETL (Viewlet)
Informatica Custom ETL (Viewlet)
Lab 2.3 Informatica Custom ETL – Main Steps
•
•
•
Create a new Repository folder
•
Define Source and Target tables
•
Create new Mapping
•
Create new Workflow
Duration: 1.0 hour
For more information on Informatica, refer to the Informatica product documentation
Lab Exercise: DAC Configuration for Customization
DAC Configuration for Customization Lab 2.4 DAC Configuration for Custom ETL – Main Steps
•
•
•
Create in DAC: – Folder – Tasks – Subject Area – Execution Plan
Duration: 1.5 hours
For more information on DAC, refer to the Oracle BI Applications Data Warehouse Administration Console Guide located on the DVD in the BI_Apps_795_Docs folder
Lab Exercise: DAC Execution and Warehouse Load Confirmation of Customization
DAC Configuration for Customization Lab 2.5 DAC Execution / Custom ETL Confirmation – Main Steps
•
•
•
Run custom Execution Plan
•
Verify data using SQL*Plus
Duration: 1.5 hours
For more information on DAC, refer to the Oracle BI Applications Data Warehouse Administration Console Guide located on the DVD in the BI_Apps_795_Docs folder
