ODI 12c Eğitimi

Datawarehouse Türkiye, eğitimlerine yaptığımız anket sonucunda en çok oy olan ODI 12c eğitimi ile devam etmektedir.23 Ocak Cumartesi günü başlayacak grup eğitimlerimiz için kontenjan 5 kişi ile sınırlıdır.

Eğitim konuları ve detayları ;

1: Install Oracle Database 11g
2: Install Oracle Data Integrator 12C
3: Database Preparations(Create users to reach ODI)
4: Oracle Data Integrator Preparations (Implementing Master and Work repository )
5. ODI ARCHITECTURE AND COMPONENTS
6. What are differents between ODI 11g and ODI 12C
7. WHAT IS ELT/ETL? We will provide examples about both of them.
8. Defining Extract , Load, Transform
9. ODI STUDIO OVERVIEW (Get to know Sections at ODI)
DESIGNER
Projects
Models
Load Plans and Scenarios
OPERATOR
Session List
Hierarchical Sessions
Load Plans and Scenarios
Scheduling
Load Plan and Scenarios
TOPOLOGY
Physical architecture
Logical architecture
Contexts
Languages
Repositories
SECURITY
Profiles
Users
Objects
STARTUP AND LOGIN
Startup Screen
Login Screen
NAVIGATION MENU
10. TOPOLOGY SETUP
PHYSICAL SCHEMA
Data Server – Book Source
Data Server – Book Target
LOGICAL SCHEMA
Logical Schema – Book Source
Logical Schema – Book Target
12. SAMPLE DATABASE
SOURCE SCHEMA OBJECTS
Tables
Source Schema HR or any schema Diagram Which we will create
TARGET SCHEMA OBJECTS
Tables
Sequences
Target Schema Diagram(We will create new schemas and tables )
13. DESIGNER SETUP
MODEL SETUP
PROJECTS SETUP
SEQUENCE SETUP
Create Sequence and using it
IMPORT KNOWLEDGE MODULES
14. APPEND DATA
15. INCREMENTAL LOADING
DATA SET
MAPPING
16. ELT USING LOOKUP TABLES
17. ELT USING JOINS
18. ELT USING UNION
19. FLAT FILE TO TABLE ELT
FILE DIRECTORY SETUP
PHYSICAL CONNECTION
LOGICAL CONNECTION
MODEL
FILE FORMAT (CSv, txt, etc…)
CREATE TABLE for target , so it must iclude columns like sample flat file
MAPPING
TNSNAMES.ORA SETUP
20. USING MARKERS
GENERATE MULTIPLE SCENARIOS USING MARKERS
21. ODI 12C NEW FEATURES – REUSABLE MAPPINGS that is different ODI 11g for some points
22. ODI 12C NEW FEATURES – SPLIT (ONE SOURCE TABLE TO MULTIPLE TARGET TABLES
23. BIGDATA Connector
24. ODI PACKAGES
PACKAGE CREATION
SCENARIO CREATION
25. ODI PROCEDURES
26. ODI VARIABLES
27. CODE MIGRATION
28. LOAD PLANNER that will include all samples
PLAN CREATION
PLAN EXECUTION
PLAN SCHEDULING
PLAN UPDATE SCHEDULE

Duration: 24 Hours
Location : Uphill Court – Ataşehir/İstanbul
Price : 1800 TL + KDV

• About
• Latest Posts

Yusuf Arslan

Sakarya Üniversitesi Bilgisayar Mühendisliği bölümünü bitirdikten sonra kariyerine Datawarehouse-Database Uzmanı olarak devam etmektedir Sitenin kurucusu ve yazarıdır.
yusufarslanbm@gmail.com adresinden bana ulaşabilirsiniz.

Latest posts by Yusuf Arslan (see all)

• Pentaho Nedir ? Yazı Dizisi-1 - Nis 18, 2016
• ODI 12c Eğitimi - Oca 3, 2016
• Veri Ambarı & ODI Online Eğitim - Ara 18, 2015