DATA MANAGER ONLINE TRAINING BY 'MENTORSINN' HYDERABAD INDIA

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