BO DI Online Training

 >>  BO DI Online Training

BO DI Online Training


 (4.8) | 750 Ratings


Introduction


BO DI Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

BO DI Online Training Course Modules

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
  • Database and application 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

 

 

Exam & Certification

0

Course Review

(4.8)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

BO DI Online Training Course Modules

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
  • Database and application 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

 

 

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry