Blog RSS Feed
Via E-mail
Twitter
Facebook
SAP BODS ONLINE TRAINING FROM MUMBAI
SAP BODI/BODS Online Training
SAP BODI/BODS Online Training Course Content
94 11.4 Maximize Parallel execution where possible using Table partitioning and DOP option
95 11.5 Splitting data flow into sub data flows using "Run as separate process" option
96 11.6 Using Bulk Loading option
97 11.7 Using Join ranks and array fetch size options
98 11.8 Using Rows per commit option
99 12 A brief view of repository tables
ID S. No. Topic Duration
1 1 Introduction to Data Warehouses, Data Marts and ETL Process 1 Hour and 30 Mins
2 1.1 Operational systems and their characteristics
3 1.2 Analytical systems (or DWHs) and their characteristics
4 1.3 Data Marts
5 1.4 Comparison of (a) Operational systems and Analytical systems and (b) Data Warehouses and Data Marts
6 1.5 Basic Data Warehouse Architecture - various layers
7 1.6 Facts and Dimensions - An example Star schema
8 1.7 Slowly Changing Dimensions - Type 1, Type 2 and Type 3 with examples
9 1.8 What is ETL - Extraction, Transformation and Load
10 1.9 Extraction types - Full and Incremental
11 1.10 Load types - Full and Incremental
12 2 Introduction to BO Data Services 45 Mins
13 2.1 Standard Data Services Achitecture - Designer, Repository, Job Server, Engine, Access Server, Administrator, Web Server and Service
14 2.2 Basic Data Services Components - Designer, Server Manager, Repository Manager and Management Console
15 2.3 Data Services Objects and Object Hierarchy
16 3 Preliminary workouts with Data Services 30 Mins
17 3.1 Create a local respository using Repository Manager
18 3.2 Configure a job server using Server Manager
19 3.3 Associate repository to the Job server
20 3.4 Connect repository to the Administrator
21 4 Working with Designer
22 4.1 Logging into the Designer 15 Mins
23 4.2 Walk through of Designer User Interface 15 Mins
24 4.3 Create and execute a simple Batch Job 3 Hours
25 4.3.1 Create DataBase DataStore and import metadata
26 4.3.2 Create and edit File formats (.txt, .csv, .xls), File format features
27 4.3.3 Create Data Flow, Work Flow, Job and Project
28 4.3.4 Execute the job and monitor its progress
29 4.4 Built-in Transforms - All important DI, DQ and Platform Transforms 8 Hours
30 4.5 DS Scripting Language and working with Functions 4 Hours
31 4.5.1 Script and the scripting language
32 4.5.2 Built-in functions (Important functions such as exec, ifthenelse, decode, is_valid_date, lookup, lookup_ext, lookup_seq, nvl, and sql
etc.)
33 4.5.3 Custom functions, Database functions and stored procedures
34 4.6 Other important Objects 2 Hours
35 4.6.1 Conditional
36 4.6.2 While loop
37 4.6.3 Try
38 4.6.4 Catch
39 4.6.5 Annotation
40 4.7 Working with variables and parameters 1 Hour
41 4.7.1 Global variables
42 4.7.2 Local variables
Page 1
ID S. No. Topic Duration
43 4.7.3 Parameters
44 4.8 Working with nested data - extracting data from XML sources 1 Hour
45 4.9 Debug features 1 Hour
46 4.9.1 using "View Where Used"
47 4.9.2 using "View Data"
48 4.9.3 using the interactive debugger
49 4.10 Working with Full sources, Time stamped sources and CDC sources 4 Hours
50 4.10.1 Implementing type 1 SCD - Full extraction
51 4.10.2 Implementing type 2 SCD - Full extraction
52 4.10.3 Implementing type 1 SCD - Incremental extraction (Time stamped source)
53 4.10.4 Implementing type 2 SCD - Incremental extraction (Time stamped source)
54 4.10.5 Implementing type 1 SCD - Incremental extraction (CDC Source)
55 4.10.6 Implementing type 2 SCD - Incremental extraction (CDC source)
56 4.10.7 Benefits of Incremental extraction over full extraction
57 5 Working in multi user environment 1 Hour
58 5.1 Setting up multi user environment - Creating, defining a connection to and activating Non-secure and Secure central repositories
59 5.2 Accessing central repository from a local repository - Adding objects, Checking out objects, Undoing check out, Checking in objects,
Filtering, Getting objects, Labeling objects, Comparing objects, Viewing object history and Deleting objects
60 6 Code migration from one phase to another phase of a project 1 Hour
61 6.1 Using Export/Import method
62 6.1.1 .ATL method
63 6.1.1.1 Exporting objects to file (.ATL)
64 6.1.1.2 Exporting whole repository to file (.ATL)
65 6.1.1.3 Importing from .ATL file
66 6.1.2 Directly exporting objects from one repository to another repository
67 6.2 Using central repository method
68 7 Processing data with problems 1 Hour
69 7.1 Using overflow files
70 7.2 Pass bad data to a database table for further analysis and action
71 8 Recovering from unsuccessful job execution 30 Mins
72 8.1 Automatic Recovery
73 8.2 Manual Recovery
74 9 DS Management Console
75 9.1 Administrator 2 Hours
76 9.1.1 Walk-through of Administrator UI
77 9.1.2 Management - Adding repositories, Managing user roles and Setting the log retention period etc.
78 9.1.3 Central repository users and groups management
79 9.1.4 Server group - Achitecture, Executing jobs using SG and the advantage of load balancing
80 9.1.5 Executing, scheduling and monitoring batch jobs
81 9.1.6 Troubleshooting - Understanding error and trace logs
82 9.1.7 Use of Export execution command option
83 9.2 Using Impact and Lineage Analysis reports 15 Mins
84 9.3 Using Operational Dashboards 15 Mins
Page 2
ID S. No. Topic Duration
85 9.4 Using Auto Documentation 15 Mins
86 10 Loading a tiny DWH - Customer Dim from relational sources, Location Dim from flat file sources, Product Dim from xml sources, Time Dim
from relational sources and Revenue Fct from relational sources; Managing dependencies between jobs
3 Hours
87 11 Performance Tuning 4 Hours
88 11.1 Using DB Indices properly
89 11.2 Maximize Push-Down using Data_Transfer transform and pushdown_sql function
90 11.3 Using proper caches
91 11.3.1 Sources - In-memory or Pageable
92 11.3.2 Lookups - NO_CACHE, PRE_LOAD_CACHE and DEMAND_LOAD_CACHE
93 11.3.3 Table Comparisons - ROW_BY_ROW_SELECT, CACHED_COMPARISON_TABLE and SORTED_INPUT
=======================================================================
full course details please visit our website www.magnifictraining.com
Duration for course is 30 days or 45 hours and special care will be taken. It is a one to one training with hands on experience.
* Resume preparation and Interview assistance will be provided.
For any further details please contact +91-9052666559 or
visit www.magnifictraining.com
please mail us all queries to info@magnifictraining.com
===========================================================================
SAP BODI/BODS Online Training
SAP BODI/BODS Online Training Course Content
94 11.4 Maximize Parallel execution where possible using Table partitioning and DOP option
95 11.5 Splitting data flow into sub data flows using "Run as separate process" option
96 11.6 Using Bulk Loading option
97 11.7 Using Join ranks and array fetch size options
98 11.8 Using Rows per commit option
99 12 A brief view of repository tables
ID S. No. Topic Duration
1 1 Introduction to Data Warehouses, Data Marts and ETL Process 1 Hour and 30 Mins
2 1.1 Operational systems and their characteristics
3 1.2 Analytical systems (or DWHs) and their characteristics
4 1.3 Data Marts
5 1.4 Comparison of (a) Operational systems and Analytical systems and (b) Data Warehouses and Data Marts
6 1.5 Basic Data Warehouse Architecture - various layers
7 1.6 Facts and Dimensions - An example Star schema
8 1.7 Slowly Changing Dimensions - Type 1, Type 2 and Type 3 with examples
9 1.8 What is ETL - Extraction, Transformation and Load
10 1.9 Extraction types - Full and Incremental
11 1.10 Load types - Full and Incremental
12 2 Introduction to BO Data Services 45 Mins
13 2.1 Standard Data Services Achitecture - Designer, Repository, Job Server, Engine, Access Server, Administrator, Web Server and Service
14 2.2 Basic Data Services Components - Designer, Server Manager, Repository Manager and Management Console
15 2.3 Data Services Objects and Object Hierarchy
16 3 Preliminary workouts with Data Services 30 Mins
17 3.1 Create a local respository using Repository Manager
18 3.2 Configure a job server using Server Manager
19 3.3 Associate repository to the Job server
20 3.4 Connect repository to the Administrator
21 4 Working with Designer
22 4.1 Logging into the Designer 15 Mins
23 4.2 Walk through of Designer User Interface 15 Mins
24 4.3 Create and execute a simple Batch Job 3 Hours
25 4.3.1 Create DataBase DataStore and import metadata
26 4.3.2 Create and edit File formats (.txt, .csv, .xls), File format features
27 4.3.3 Create Data Flow, Work Flow, Job and Project
28 4.3.4 Execute the job and monitor its progress
29 4.4 Built-in Transforms - All important DI, DQ and Platform Transforms 8 Hours
30 4.5 DS Scripting Language and working with Functions 4 Hours
31 4.5.1 Script and the scripting language
32 4.5.2 Built-in functions (Important functions such as exec, ifthenelse, decode, is_valid_date, lookup, lookup_ext, lookup_seq, nvl, and sql
etc.)
33 4.5.3 Custom functions, Database functions and stored procedures
34 4.6 Other important Objects 2 Hours
35 4.6.1 Conditional
36 4.6.2 While loop
37 4.6.3 Try
38 4.6.4 Catch
39 4.6.5 Annotation
40 4.7 Working with variables and parameters 1 Hour
41 4.7.1 Global variables
42 4.7.2 Local variables
Page 1
ID S. No. Topic Duration
43 4.7.3 Parameters
44 4.8 Working with nested data - extracting data from XML sources 1 Hour
45 4.9 Debug features 1 Hour
46 4.9.1 using "View Where Used"
47 4.9.2 using "View Data"
48 4.9.3 using the interactive debugger
49 4.10 Working with Full sources, Time stamped sources and CDC sources 4 Hours
50 4.10.1 Implementing type 1 SCD - Full extraction
51 4.10.2 Implementing type 2 SCD - Full extraction
52 4.10.3 Implementing type 1 SCD - Incremental extraction (Time stamped source)
53 4.10.4 Implementing type 2 SCD - Incremental extraction (Time stamped source)
54 4.10.5 Implementing type 1 SCD - Incremental extraction (CDC Source)
55 4.10.6 Implementing type 2 SCD - Incremental extraction (CDC source)
56 4.10.7 Benefits of Incremental extraction over full extraction
57 5 Working in multi user environment 1 Hour
58 5.1 Setting up multi user environment - Creating, defining a connection to and activating Non-secure and Secure central repositories
59 5.2 Accessing central repository from a local repository - Adding objects, Checking out objects, Undoing check out, Checking in objects,
Filtering, Getting objects, Labeling objects, Comparing objects, Viewing object history and Deleting objects
60 6 Code migration from one phase to another phase of a project 1 Hour
61 6.1 Using Export/Import method
62 6.1.1 .ATL method
63 6.1.1.1 Exporting objects to file (.ATL)
64 6.1.1.2 Exporting whole repository to file (.ATL)
65 6.1.1.3 Importing from .ATL file
66 6.1.2 Directly exporting objects from one repository to another repository
67 6.2 Using central repository method
68 7 Processing data with problems 1 Hour
69 7.1 Using overflow files
70 7.2 Pass bad data to a database table for further analysis and action
71 8 Recovering from unsuccessful job execution 30 Mins
72 8.1 Automatic Recovery
73 8.2 Manual Recovery
74 9 DS Management Console
75 9.1 Administrator 2 Hours
76 9.1.1 Walk-through of Administrator UI
77 9.1.2 Management - Adding repositories, Managing user roles and Setting the log retention period etc.
78 9.1.3 Central repository users and groups management
79 9.1.4 Server group - Achitecture, Executing jobs using SG and the advantage of load balancing
80 9.1.5 Executing, scheduling and monitoring batch jobs
81 9.1.6 Troubleshooting - Understanding error and trace logs
82 9.1.7 Use of Export execution command option
83 9.2 Using Impact and Lineage Analysis reports 15 Mins
84 9.3 Using Operational Dashboards 15 Mins
Page 2
ID S. No. Topic Duration
85 9.4 Using Auto Documentation 15 Mins
86 10 Loading a tiny DWH - Customer Dim from relational sources, Location Dim from flat file sources, Product Dim from xml sources, Time Dim
from relational sources and Revenue Fct from relational sources; Managing dependencies between jobs
3 Hours
87 11 Performance Tuning 4 Hours
88 11.1 Using DB Indices properly
89 11.2 Maximize Push-Down using Data_Transfer transform and pushdown_sql function
90 11.3 Using proper caches
91 11.3.1 Sources - In-memory or Pageable
92 11.3.2 Lookups - NO_CACHE, PRE_LOAD_CACHE and DEMAND_LOAD_CACHE
93 11.3.3 Table Comparisons - ROW_BY_ROW_SELECT, CACHED_COMPARISON_TABLE and SORTED_INPUT
=======================================================================
full course details please visit our website www.magnifictraining.com
Duration for course is 30 days or 45 hours and special care will be taken. It is a one to one training with hands on experience.
* Resume preparation and Interview assistance will be provided.
For any further details please contact +91-9052666559 or
visit www.magnifictraining.com
please mail us all queries to info@magnifictraining.com
===========================================================================
