GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  ETL

 Print  |  
Question:  Cognos vs Informatica

Answer: can anybody tell me that what are the processes used by cognos and Informatica for ETL Extraction, Scrubbing and Fusion. If you have any detailed report then please send me on
my mail ID...
nm_105@yahoo.co.in

thanks in Advance...


September 09, 2009 04:56:44 #1
 raambharathi   Member Since: September 2009    Total Comments: 1 

RE: Cognos vs Informatica
 
Cognos and Informatica are not same tool that does the same work.

Informatica is a ETL tool.  It extracts data from various sources (Oracle, db2,
Sybase, etc) transforms it and loads data into the warehouse.

Cognos is a reporting tool. 
It is used for business purpose to generate some reports (may be pictorial or
statistical representation).   It uses the datawarehouse information to generate a report.

Oracle business intelligence is another reporting tool which is becoming famous
today.
     

 

Back To Question