Solved

ETL

Posted on 2010-11-20
13
797 Views
Last Modified: 2013-11-10
I am familiar with data modelling , cognos, cognos framewrok model, sql. But I want to learn more about ETL. Can someone please let me know of some self learn links or video tutorials that will help me become good at ETL concepts and also maybe a ETL tool with an example project. I learn better by examples. I want to also know how it is used on  organization which have disparate data sources and on top of that have mergers. What type of maintainence do they have to do... and so on...

PLease help...!



0
Comment
Question by:Sara_j_11
  • 3
  • 3
  • 2
  • +2
13 Comments
 
LVL 5

Accepted Solution

by:
dacasey earned 168 total points
ID: 34181358
0
 

Author Comment

by:Sara_j_11
ID: 34181411
and then where do I take it from there. Would this give me enough to be an entry level ETL person.
The screen shots are small and kind of very hard to see...
ARe there are video tuorials or maybe a screen reader so I can hear it versus seeing it for the text part..???
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 34182049
As a good ETL Developer, learn these ETL Tools:
INFORMATICA
COGNOS
SSIS (SQL Server Integration Service )

these 3 tools are the most powerful ETL softwares. Here is SSIS Forum and experts here can help you lot to be professional in SSIS, but I strongly recommend to install whole 3 softwares and read books to be a Professional ETL Developer.
0
 
LVL 22

Assisted Solution

by:8080_Diver
8080_Diver earned 166 total points
ID: 34190443
I would also recommend becoming really, really good at SQL. ;-)

Essentially, learning to do ETL is like learning to ride a bicycle . . . you can read all the books you want to and study it as much as you choose, but, at some point, you have to actually get on the bicycle and try to reide it.  Doing so will generally result in some skinned knees along with a whole new understanding of what is involved in actually riding a bicycle.  Learning to do theoretical ETL can be accomplished from books.  Learning to actually do ETL is only going to come with practice doing it.

The Good News is that SQL Server Express 2005 comes with a BIDS component set.  The Bad News is that you can't actually schedule the packages using SQL Server Express.  However, you can execute them in the BIDS development environment.

I don't know if Informatica and COGNOS have free versions of their tools (although I certainly plan on checking ;-).

Oracle also has a form of ETL handling, I believe.
0
 

Author Comment

by:Sara_j_11
ID: 34259396
can someone tell me if one has free resources to learn oracle Etl or SSIS - I would like to get  links on free resources on either one, to start with... I already know the BI aspect of cognos. I mean I have done dimensional data modelling in Cognos framework manager and powerplay. Is thatwhat u mean by ETL? Or is cognos ETL different?
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 22

Expert Comment

by:8080_Diver
ID: 34260116
Sara_j_11,

ETL means Extract, Transform, and Load.  It has nothing to do with a particular product or, even, whether or not a data warehouse is involved.  I have several ETL packages that are manipulating data and loading it into OLTP databases and some that are doing the same thing exceopt the load is into an OLAP database.  So, ETL is a tool that can be used for whatever it is appropriate to accomplish.

As I said, SQL Server 2005 Express comes with a bids component that lets you set up SSIS packages and execute them . . . you just can't schedule them. ;-)  On the other hand, if you are really wanting to learn SSIS, you can buy SQL Server 2008 Developer edition for about $50 and that does come with SSIS (and is the equivalent to the Enterprise Edition ;-).

As for Oracle, there is also a free/"Express" version of Oracle but I have no knowledge about what comes with that one.

0
 
LVL 22

Expert Comment

by:8080_Diver
ID: 34260130
Also, there are some good tutorial videos on the Pragmatic Works web site (http://www.pragmaticworks.com/), among others.
0
 
LVL 30

Assisted Solution

by:Reza Rad
Reza Rad earned 166 total points
ID: 34261211
As 8080_Diver explained , Dimensional Data Modeling and ETL are different things,
ETL gather up data, and can not be relevant to any data warehouse,
but using ETL combined with Data warehouse is needed in most cases.
by the way, you can learn SSIS with great book here:
http://www.wrox.com/WileyCDA/WroxTitle/Professional-Microsoft-SQL-Server-2008-Integration-Services.productCd-0470247959.html
this is one of the best books on SSIS.

also you can ask your questions here any time, 8080_Diver, me and other experts here will help you on issues about  SSIS.

0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 34283656
You should select a Tech book (and in this field I suggest SSIS Wrox book), but also a conceptual book like onde from Kimball Group.
Regards,
Pedro
0
 

Author Comment

by:Sara_j_11
ID: 34390787
I got familiar a little bit about ETL , but I dont really seem to get a grasp on the framework  behind real time datawarehousing. I understand that it is more like 24/7 and that it uses some sort of services. But what are really these services.... can u please help me understand this better?
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 35458516
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to recover a database from a user managed backup
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now