COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: psandhya408 on 25 Sep 2013 06:16:25 PM

Title: convert informatica mapping to cognos report
Post by: psandhya408 on 25 Sep 2013 06:16:25 PM
Hi ,

I have a requirement where in I have to use imformatica mapping logic and implement in cognos and develop a report.

I understood the mapping but unable to program in cognos

I have a table where a router is used and divided into 6 0r 7 tables based on the fliter .

the expression transformation are used to calculate percentage of the existing rows.
Again all the tables are unioned.


How to implement this in cognos
Title: Re: convert informatica mapping to cognos report
Post by: blom0344 on 26 Sep 2013 03:47:59 AM
Do you mean in Cognos ETL?  Informatica basically processes the data. You cannot really transform an ETL proces into a report. You would need Cognos data manager or another ETL tool..