Course Duration in Hours
History and Fundamentals of Data-warehousing in Depth.
Star Schema And Extended Star Schema Techniques.
Clear picture on OLTP and OLAP systems
Introduction to SAP HANA
SAP In-Memory Strategy
HANA compare to BW
IMCE and Surroundings (In memory Computing Engine)
Row Store & Column Store
Installation and deployment scenarios
Introduction to HANA Studio
HANA Administration Prospective
LT (Landscape Transformation) OR Trigger Based Replication
Remote Function Calls
Creating RFC Destinations in SAP ABAP
Replicating SAP tables from OLTP Server using Trigger based Replication
Real time Replication
Job Scheduling and monitoring.
Parallel and Multi-Thread processing.
Table Creation, Modification, Updating and Deletion operations.
SQL Select Statements
Joins and Unions
CE (Calculation Engine) Functions.
Aggregations and lot more.
Applying star schema technique in SAP HANA
Time Data Generation
Variables & Input Parameters
Calculated & Restricted Columns
Currency & Quantity Conversions
Star Joins, Cubes & Dimensions
SQL Script based Views
Calculation Engine Functions Depth.
HANA -ETL Replication Methodology
BODS (Business Object Data services)
HANA As a Central Repository
JDBC & ODBC connectivity.
Replicating data from SAP OLTP Server Using BODS
Replicating data from Flat File Source systems
Replicating data from BI System
Backward replication technique.
Bulk Load & Scheduling
Extracting ECC data using BW Extractors
Scheduling Stored Procedures
Transformations using BODS
Pivot & Reverse Pivot Transformations
Key Generation Transform
Real time scenarios
Project development in SAP HANA Development perspective
Capturing the changes in Delivery unit
Basics of XSJS and ODATA service to expose the data to front end
Real time issues which you can come across during actual project development
Newly supported features with HANA SP10
SAP BO/ BI/ BW Professionals, Informatica, DBA professionals generally prefer to migrate to SAP HANA,
otherwise any professional with basic SQL knowledge can learn SAP HANA.
Red Coin Technologies, Marathahalli (Bangalore),Bangalore,IN