Need some information regarding data warehousing field

Posted by Mirage on Stack Overflow See other posts from Stack Overflow or by Mirage
Published on 2010-05-05T01:05:39Z Indexed on 2010/05/05 1:38 UTC
Read the original article Hit count: 262

Filed under:

data-warehouse

|

datawarehousing

|

sql

|

Oracle

I am a web developer and i would like to shift my field to data warehousing. Can anyone please give me some idea , which langauges or stuff i need to learn like cogonos , datastage, etl

or IF anyone currently working can guide me how can i start , i will thankful to you. DO i nned to do oracle because i know mysql , sql. My basic understanding with databse is good. Any books

© Stack Overflow or respective owner

Related posts about data-warehouse

PostgreSQL to Data-Warehouse: Best approach for near-real-time ETL / extraction of data

as seen on Stack Overflow - Search for 'Stack Overflow'
Background: I have a PostgreSQL (v8.3) database that is heavily optimized for OLTP. I need to extract data from it on a semi real-time basis (some-one is bound to ask what semi real-time means and the answer is as frequently as I reasonably can but I will be pragmatic, as a benchmark lets say we… >>> More
Time and date dimension in data warehouse

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm buildind an data warehouse. Each fact has it's timestamp. I need to create reports by day, month, quater but by hours too. Loking at the examples I see that dates tend to be saved in dimension tabels. But I think, that it makes no sense for time. The dimension table would grow and grow. On the… >>> More
Oracle Healthcare Data Warehouse Foundations RELEASED!

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Since I joined Oracle I've been working on Oracle Healthcare Data Warehouse Foundations (OHDF). It was officially released earlier this month at HIMSS. But for over 2 months prior to that I had to keep it a secret. It was so tough; I didn't even tell my family when they asked me what I was working… >>> More
BIWA Wednesday TechCast Series - Opposition to Data Warehouse Initiatives

as seen on Oracle Blogs - Search for 'Oracle Blogs'
BIWA Wednesday TechCast Series - 19th Event! Opposition to Data Warehouse Initiatives Please join us for this webcast on Wednesday, March 24, 12 noon Eastern or check your local area's time Webcast is open to clients, prospects and partners. No matter how good your technology and technical skills… >>> More
OpenWorld on your iPad and iPhone

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Most of you probably know that each year I publish a data warehouse guide for OpenWorld which contains links to the latest data warehouse videos, a calendar for the most important sessions and labs and a section that provides profiles and relevant links for all the most important data warehouse presenters… >>> More

Related posts about datawarehousing

Tech Article: Using Oracle GoldenGate for Real-Time Data Integration

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Learn how to install, set up, and configure Oracle GoldenGate to easily achieve seamless replication of data between Oracle Database 10g and 11g. >>> More
Tech Article: Oracle Essbase Studio Deep-Dive

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Dive into a step-by-step tutorial that reflects real-world data warehousing complexities. >>> More
Finding the maximum value/date across columns

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
While working on some code recently I discovered a neat little trick to find the maximum value across several columns….. So the starting point was finding the maximum date across several related tables and storing the maximum value against an aggregated record. Here's the sample setup code:… >>> More
Insert into a star-schema

as seen on Stack Overflow - Search for 'Stack Overflow'
I've read a lot about star-schema's, about fact/deminsion tables, select statements to quickly report data, however the matter of data entry into a star-schema seems aloof to me. How does one "theoretically" enter data into a star-schema db? while maintaining the fact table. Is a series of INSERT… >>> More
What is the best FREE solution to implement one ETL project in MySql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, What is the best FREE solution to implement one ETL project in MySql? Regards, Pedro >>> More