Facebook Twitter google plus LinkedIn

Email:contact@psntrainings.com
india:Whatsapp No+91 86860 29160 USA:+1 228 586 3560

BODI Training



Psntrainings is the Best BODI Online Training institute in Hyderabad,india

Course Description

INTRODUCTION TO DATA INTEGRATOR

  • About Data Integrator
  • Data Integrator product documentation

DATA INTEGRATOR ARCHITECTURE:

  • Standard Data Integrator components
  • Optional Data Integrator components
  • Data Integrator management tools
  • Data Integrator operating system platforms
  • Data Integrator distributed architecture

DATA INTEGRATOR DESIGNER

INTRODUCTION TO DATA INTEGRATOR DESIGNER:

  • Logging in to the designer
  • Designer overview
  • Data Integrator objects
  • Working with objects
  • General and environment options
  • Projects and Jobs
  • Data stores
  • File formats
  • Data flows
  • Work flows
  • Nested data
  • Real-time jobs
  • Embedded data flows
  • Variables and Parameters
  • Executing jobs
  • Data Quality
  • Design and Debug
  • Data Cleansing

TRANSFORMS:

  • About transforms, operation codes
  • Address _ Enhancement
  • Case
  • Date _ Generation
  • Effective _ Date
  • Hierarchy _ Flattening
  • History _ Preserving
  • Key _ Generation
  • Map _ CDC _ Operation and Map _ Operation
  • Match _ Merge
  • Merge Name _ Parsing
  • Pivot(columns to rows) and Reverse Pivot(rows to columns)
  • Query
  • Row _ Generation
  • SQL
  • Table _ Comparison
  • Validation
  • XML _ Pipeline

FUNCTIONS AND PROCEDURES:

  • Overview of functions
  • About functions
  • Custom functions
  • Description of built-in functions
  • About procedures
  • Calling stored procedures
  • In general
  • From queries
  • Without the function wizard

DATA INTEGRATOR SCRIPTING LANGUAGE:

  • About scripting language
  • Language syntax
  • Syntax for statements in scripts
  • Syntax for column and table references in expressions
  • Strings
  • Quotation marks
  • Escape characters
  • Trailing blanks
  • Variables
  • Variable interpolation
  • Functions and Stored procedures
  • Operators
  • NULL values
  • NULL values and empty strings
  • Debugging and Validation
  • Keywords
  • Sample scripts
  • Export/import

DATA INTEGRATOR ADMINISTRATOR:

  • Introduction
  • Administrator Management
  • Central Repository Management
  • Using Server Groups
  • Executing batch jobs
  • Scheduling jobs
  • Trace and monitoring jobs
  • Export Execution command
  • Using the Administrator
  • Using a third-party scheduler
  • Data Integrator job launcher

DATA INTEGRATOR METADATA REPORTS:

  • Introduction
  • Viewing Metadata Reports

DATA INTEGRATOR PERFORMANCE OPTIMIZATION:

  • Introduction
  • Environment Test Strategy
  • Measuring and Tuning Data Integrator Performance
  • Using Bulk Loading
We are offered MSBI online training also


Enquiry