Training:
“PSP Technologies Private Limited is a highly creative and innovative consulting and product development group located in the beautiful city of Chennai, South Inida offers training in
SAP
PeopleSoft
Oracle Applications
Data Warehousing
ORACLE APPLICATIONS – MODULES:
1. ORACLE APPS TECHNICAL
2. ORACLE APPS FINANCE
3. ORACLE APPS MANUFACTURING
4. ORACLE APPS DISTRIBUTION
SAP Modules:
ABAP/4, BASIS,BI, MM PP, HR
ABAP-HR,FICO, SD, APO EP, HCM
IS-RETAIL, PLM, PM, SCMCRM
Data Warehousing :
INTRODUCTION:
Warehousing, what is it, who needs it and why?
Designing and modeling for OLTP systems
Dimensional modeling for data warehousing
Data warehousing bus architecture
Star schema design
Snow flake design galaxy
Dimension, SCD, large and degenerate dimension
FACT table, FACTLESS FACT table, dimension table
Additive, semi-additive and non-additive FACTS
MOLOP, ROLAP, HOLAP
EXTRACTION, LOADING TRANSFORMATION :
Fundamental of ETL architecture
INFORMATICA (power center) :
Repository :
Introduction to power center repository
Enterprise data mart architecture
Repository creation
Local & global
Repository manager
Repository manager components
managing the repository
Promoting
Adding
backing up
Restoring
Deleting
Repository security
working with folders
Local and global shortcuts
Exporting and importing objects
Designer:
Using the designer tool and windows
working with the source
working with the target
working with the mapping
Transformation (reusable components)
Mapping parameters and variables
using the debugger
Previewing data
managing the business components
Cubes and dimensions in informatica
Slowly growing target
Slowly changing dimension type 1, 2, 3
Understanding different strategies for implement SCD
implementing the strategies for SCD
Contact us :
PSP Technologies Private Limited
15, South West Boag Road,
T. Nagar, Chennai-600017.
mailto:info@psptech.in
url :http://www.psptech.in