Link to home
Start Free TrialLog in
Avatar of Sara_j_11
Sara_j_11

asked on

ETL

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...!



ASKER CERTIFIED SOLUTION
Avatar of dacasey
dacasey
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sara_j_11
Sara_j_11

ASKER

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..???
Avatar of Reza Rad
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
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.

Also, there are some good tutorial videos on the Pragmatic Works web site (http://www.pragmaticworks.com/), among others.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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?
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.