You are here: Home > Training Institute
All posts from

psptech.in PSP Technologies Pvt Ltd Chennai : SAP, Oracle Applications, Data Warehousing Training

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

Want to comment on this post?
Go to bottom of this page.

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

Leave a Reply

How to add comment : 1) Type your comment below. 2) Type your name. 3) Post comment.

IndianJobTalks © 2022

Contact Us   Privacy Policy   SiteMap