Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help!!

Status
Not open for further replies.

jht7272

Programmer
Dec 6, 2007
1
US
i know this is purely technical area but i would be grateful if experts in industy can guide me..

my confusion is what to choose between COGNOS or INFORMATICA, i have IT Background and want to move in to dataware housing field.

before i have worked in .net for a yr.

waiting for replying posts!

thx
 
Please use descriptive posts. Help! definately is not!

INFORMATICA is the world's leading ETL shop, whereas Cognos has it's main focus on reporting,OLAP and analysis.

Cognos also has it's own ETL-tool, but it is a niche product.

So mainly it is a backend/frontend differentiation

Ties Blom

 
Informatica technologies are focused on integration. The Informatica ETL is one of the world best.

Cognos technologies are focused on query reporting (relational, OLAP). Cognos ETL (Data Manager) is good tool which has a strong integration with Cognos modelisation tool (Framework Manager). However, it may disappear because IBM offers a very complete and competitive ETL called DataStage.
 
Oh, I would definitely choose Cognos, that's the one for you, nobody houses dataware like Cognos.
 
I have worked 6 years with Informatica's Powercenter and I have seen Cognos Decision Stream (or whatever it is called now) Informatica needn't worry, this is no competion to them.
Other than that, Informatica's products are polished to a level that is definitely beyond the reach of any BI vendor. It all comes at a hefty price, but boy it is a joy to work with.

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top