Data Manager Training

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