Hi ,
We are doing a survey to find out the Cognos ETL tools. I would like to know if Transformer can be used as an ETL tool or is it purely to build cubes based on EDW data. Is Cognos Data manager part of Cognos Transformer and how good it is as an ETL tool . Thanks.
Is there a reason you would not use Data Manager for your ETL?
Data Manager is the Cognos ETL tool and is separate from Transformer. We do not use DM here, so I cannot tell you how well it works. By the way, Transformer cubes can be built off many decidedly non-EDW data sources.
Quote from: cognos10dev on 14 Oct 2011 11:11:14 AM
Hi ,
We are doing a survey to find out the Cognos ETL tools. I would like to know if Transformer can be used as an ETL tool or is it purely to build cubes based on EDW data. Is Cognos Data manager part of Cognos Transformer and how good it is as an ETL tool . Thanks.
Transformer is purely a tool for designing and building Powercubes, so is not really an ETL tool in the strictest sense.
Data Manager is a separate tool from Transformer, and is very, very good at delivering star schemas into a conformed dimension data warehouse.
Regards,
MF.