Data Manager Online Training

Data Manager Course Content

  • Examine derivations
  • Apply operators and functions to derivations
  • Examine the derivation timing model
  • Add derivations to a fact build
  • Create Conformed Dimensions

  • Examine conformed dimensions and their advantages
  • Design conformed dimensions
  • Create conformed dimensions
  • Create data integrity lookups that use conformed dimensions
  • Customize Reference Structures

  • Create hierarchies manually using different approaches
  • Examine the features of a hierarchy
  • Examine literals
  • Set data access for hierarchy levels
  • Examine static and dynamic members
  • Examine fostering
  • Use derivations in a hierarchy
  • Process Dimensional History and Late Arriving Facts

  • Examine slowly changing dimensions (SCDs)
  • Use surrogate keys in SCDs
  • Manage type 1 and type 2 changes to dimensional data
  • Load historical data for a dimension
  • Examine late arriving facts
  • Process late arriving facts in a fact build
  • Transform Data Using Lookups and Derived Dimensions

  • Identify when to use lookups
  • Identify the requirements for a lookup
  • Create a translation lookup
  • Create an optional lookup
  • Add derived dimensions to fact builds
  • Customize Data Delivery

  • Configure fact and dimension delivery modules
  • Create indexes on fact and dimension tables
  • Update fact data using keys
  • Customize Fact Data Processing

  • Filter fact data
  • Merge duplicate fact data
  • Examine fact data integrity checking
  • Reject fact data
  • Aggregate, Filter, and Partition Fact Data

  • Aggregate fact data
  • Examine aggregate rules
  • Vertically restrict fact data
  • Horizontally restrict fact data
  • Partition fact data
  • Implement Job Control

  • Examine where job control fits into the data warehouse lifecycle
  • Create a JobStream
  • Add, link, and reposition nodes
  • Execute a JobStream and view the results
  • Automate Functionality Using Commands

  • Differentiate between the Command Line Interface (CLI) and Data Manager Designer
  • Identify common commands
  • Use commands in a batch file
  • Examine variables
  • Customize Functionality with User-Defined Functions and Variables

  • Examine user defined functions (UDFs)
  • Create an internal UDF
  • Create a user-defined variable
  • Process Unbalanced Hierarchical Data

  • Examine balanced, unbalanced, and ragged hierarchies
  • Add a recursive level to a hierarchy
  • Identify ways to balance a hierarchy and delivered flattened data
  • Examine circular references
  • Pivot Fact Data

  • Examine pivoting
  • Use the single pivot technique
  • Use the advanced pivot technique
  • Examine reverse pivoting
  • Resolve Data Quality Issues

  • Identify data quality and cleansing issues
  • Handle fostered and unmatched members
  • Perform debugging using SQLTerm and functions
  • Assess the quality of output data
  • Troubleshoot and Tune the Data Manager Environment

  • Use build logging to ensure that data marts are being loaded properly
  • Perform dimension breaking
  • Manage memory and resources
  • Export DDL statements
  • Organize and Package Data Manager Components

  • Export and import components using packages
  • Search for components in a catalog using Navigator
  • Integrate with IBM Cognos BI

  • Examine IBM Cognos BI
  • Identify the role of metadata dimensions, metadata collections, and metadata stars
  • Export Data Manager metadata to XML
  • Import Data Manager XML into Framework Manager
  • Use Data Manager metadata with IBM Cognos BI
  • Publish a data movement task to IBM Cognos Connection

Contact Us

Tel: +91-8897400222
USA: +1-512-800-7568
EMAIL: info@mentorsinn.com

Testimonials

" The DataManager training was very good, training was conducted by real time expers, thanks for the support. " - Abhi (Datamanager)