Data Stage training

DATASTAGE Course Content

  • Data Warehouse Concepts, Design.
  • Need of Data Warehouse.
  • Introduction to OLTP, ETL and OLAP Systems.
  • Data Warehousing Architecture.
  • Dimensional Modeling.
  • Data Marts and ODS.
  • Star Schema and Snowflake Schema.
  • Types of Fact and Dimension Tables.
  • Testing of Data warehouse.
  • FAQ’s.

ORACLE CONCEPTS

  • Introduction to Oracle.
  • Data Types.
  • Select statement usage.
  • Joins.
  • Sub Queries.
  • Performance Tuning Tips & Tricks.
  • FAQ’s.

 DATASTAGE-INTRODUCTION

  • Introduction to ETL.
  • ETL Architecture.
  • Datastage Architecture.
  • Installation & Configuration of Datastage.
  • Creation of the Project.

DATASTAGE-CREATING DATASTAGE JOBS

  • Design the Datastage jobs.
  • Compile and Running jobs.
  • View the job log and debugging of jobs.
  • Simple and Complex jobs.
  • Jobs creation with Multiple Sources.
  • Multiple Targets.

TRANSFORMING DATA

  • Using the Active stages and passive stages.
  • Example of each Transformation available.
  • Working with Relational Data.
  • Slowly Changing Dimensions.
  • Performance tuning techniques.
  • Handle errors and exceptions.
  • Stage Variables, Derivations and Constraints.
  • Functions.

 Platform Architecture:

  • Describing configuration files.
  • Defining Environmental Variables.
  • Defining Job level parameters.
  • Describing Runtime column propagations.
  • Exporting and importing the jobs.
  • Clear the logs and Cleanup the Resources.
  • Job Sequences and Job Activity.

 ADVANTAGES

  • Real-time Scenarios.
  • Deployment Process.
  • Project Experience.
  • Resume Preparation.
  • Mock Interviews.
  • FAQ’s.
  • Job Assistance.

 

Sgraph Infotech
MSBI | DOT NET | AWS | Data Science | Python
Address :
3rd Floor, JP Royale- 90/4, Above ICICI Bank, Outer Ring Road, Opposite Radisson Blu, Marathahalli,
Bengaluru,
Karnataka - 560037
India.
Tel : 9620885025
Email : sgraphinfotech@gmail.com

OUR TRAINING COURSES

Best Android Training in Marathahalli Bangalore

Best .Net Training in Bangalore

Best Oracle SQL Training Institutes in Bangalore

Best PLSQL Training Centers in Bangalore

Best Big Data and Hadoop Training Courses in Bangalore

Best MSBI Training Institutes in Bangalore

Best Microsoft Power BI Training Bangalore

Best Oracle DBA Training at Bangalore

CONTACT FORM

© 2016 | All rights reserved |Developed By Nexevo Technologies | Sitemap