Datamanger online training from visakhapatnam

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