Cognos Decisionstream

Cognos DecisionStream architecture

Cognos DecisionStream is a powerful ETL tool, comprised of a DecisionStream designer graphical design environment and an ETL engine acting as a server.
The Cognos Decision Stream designer is a graphical tool for implementing the ETL process. It lets users map data sources into data streams, define transformations of the data, organize facts and dimensions into a star or snowflake schema, etc.

The DecisionStream designer comprises of the following components shown below:

Dimension library
Dimension library browser with many dimensional templates. DecisionStream provides templates for managing surrogate keys and slowly changing dimensions (SCD).
Dimension and Fact builds
Dimensions and facts builds are defined by ETL developers, a module used for managing the ETL process
Visual design environment
ETL process designer which lets developers design a flow. The visual designer provides the main four views to manage the ETL process:
- Marketing perspective
- Data Stream
- Transformation Model
- Fact Delivery

Cognos DecisionStream web resources

Cognos DecisionStream advanced analytics
Cognos DecisionStream advanced analyticsCognos Business Intelligence with Data Mining presentation illustrates the use of Cognos DecisionStream in data warehousing and data mining processes. It shows how to deploy data...
Cognos DecisionStream tour
Cognos DecisionStream tourThe Cognos DecisionStream quick tour provides 12 slides which guide through the architecture of the Cognos ETL Tool. It provides an overview of the DecisionStream dimensional...