| Data Warehousing & Business Intelligence Success |
|
| Success Stories - Office Automation | |
|
CHALLENGE: The goal of the application was to capture the entire life cycle of a printer, from the day it is made to the day it is scrapped. COGENT team built a Data Mart that contained all printer data like production date, sales date, warranty information, sales information, ship date, total sales, cumulative sales, returns, and repairs, scrapped, customer information, etc.
COGENT Solution:• Designed Logical and Physical data models using Erwin data modeling tool.• Used Datastage for Purpose of Extraction, Loading and Transformation. • Re-design target databases without changing any source database and tables. • Created Suitable environment for generating enterprise wide report in Microstrategy. TOOLS USED: Ascential DataStage 7.X/6.0 (Designer, Director, Manager, Administrator), PL/SQL, Oracle 9.i, PL/SQL, Shell scripts, Procedures and Windows 2000 Professional |
|
| < Prev | Next > |
|---|
COGENT News
Testimonials
“…quickly proven to be a leader. ..have consistently provided the highest quality services while maintaining their competitive position… COGENT represents the best value for technical outsourcing.”
“…outstanding performance...has been a most effective and productive associate on this project, largely due to his superior quality of work and exceptional technical abilities…”
Contact COGENT
Contact us today here...

