If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Connection between informatica and cognos

Started by priyanka, 17 Dec 2015 07:27:17 AM

Previous topic - Next topic

priyanka

Could you please tell me what is exact connection between cognos and informatica when reports in cognos are triggered by informatica workflow and reports will not generate if informatica flow is failed .what is exact reason?

sunosoft

For me it seems like trigger based scheduling has been enbabled for ur reports. You might check with ur admin for more details. Please check below link for trigger based scheduling in cognos.

https://www-304.ibm.com/support/docview.wss?uid=swg21340069
Thanks
SK

priyanka

Thanks.But I just want to ask what exactly Informatica does?

mcc.chernandez

When the INFA workflow completes you setup a process to call the trigger.bat with the corresponding Cognos job's trigger name

bdbits

Quote from: priyanka on 18 Dec 2015 07:23:50 AM
Thanks.But I just want to ask what exactly Informatica does?

OK, I'll take a stab at your question. :) 

Informatica is an ETL tool, which means it reads your data sources and updates your data warehouse. It appears that in your organization, if the ETL (Informatica workflow) fails and thus the data has not been successfully updated, they do not want the reports to run.

sdf

Yup, you would not want to see a report with outdated/wrong values right?