Results 1 to 8 of 8
  1. #1
    All-Star
    Points: 33,146, Level: 56
    Level completed: 8%, Points required for next Level: 1,104
    Overall activity: 1.0%
    Achievements:
    Veteran25000 Experience Points
    Jonecy's Avatar
    Join Date
    Dec 2006
    Location
    3.5 Hours From Trice
    Posts
    1,264
    Points
    33,146
    Level
    56
    Thumbs Up
    Received: 0
    Given: 0

    Any ETL Experts Out There?.....

    I have the opportunity to get some training on a new ETL tool for work and my 2 primary options are Informatica or DataStage.

    For any of you who have worked with either of these tools, can you provide your input on which tool you would prefer to get trained on and why? That's ultimately what I need to decide in the upcoming weeks.

    Thanks!


    - 的知 not a spin my wheels type of guy." - Coach Paul Rhoads

  2. #2
    Walk On
    Points: 8,653, Level: 27
    Level completed: 84%, Points required for next Level: 97
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    SImpsonCy's Avatar
    Join Date
    Dec 2006
    Location
    Des Moines
    Posts
    157
    Points
    8,653
    Level
    27
    Thumbs Up
    Received: 0
    Given: 0

    Re: Any ETL Experts Out There?.....

    We use DataStage at work. For what ever reason they sent only the DBA to a training class so the rest of us have been left to our own to figure it out. If you are a stable guy at your work place I'd say take the training that lets you work with the people and projects you like. If you are like some of my friends, you might want look around the workforce and see which product lends itself to making you more appealing. As for the DS, great way to push and pull files between systems. Using it to created warehouses and datamarts in an automated fashion. A class would be great to hit those things that we don't know, I'd love to know how to make an XML output from a flat file input, that is what I am working on now.


    Fight with Might!

    My Blog

  3. #3
    Prospect
    Points: 4,929, Level: 20
    Level completed: 70%, Points required for next Level: 121
    Overall activity: 3.0%
    Achievements:
    Veteran1000 Experience Points

    Join Date
    Apr 2006
    Posts
    9
    Points
    4,929
    Level
    20
    Thumbs Up
    Received: 0
    Given: 0

    Re: Any ETL Experts Out There?.....

    Since I work in Informatica , my opinion is probably a little biased towards it. Informatica is more programmer friendly. Datastage generally needs more jobs than Informatica because it calls for landing data between transformations. Informatica is more easier to work with MPP databases (they offer loaders for TD,Greenplum, Neteeza etc) and also offers Application Connections to Hadoop among others. It is well positioned to enter into the MDM & Cloud Computing space.

    Informatica is used more widely in the market. DataStage however is a growing tool and since being bought out by IBM a few years back, it is becoming a more popular tool.


    SV

  4. #4
    All-Star
    Points: 33,146, Level: 56
    Level completed: 8%, Points required for next Level: 1,104
    Overall activity: 1.0%
    Achievements:
    Veteran25000 Experience Points
    Jonecy's Avatar
    Join Date
    Dec 2006
    Location
    3.5 Hours From Trice
    Posts
    1,264
    Points
    33,146
    Level
    56
    Thumbs Up
    Received: 0
    Given: 0

    Re: Any ETL Experts Out There?.....

    Thanks for the feedback - both replies seem consistent with some of the other research I've done as well. It will be interesting to see how popular DataStage gets now that's under the IBM name. I'm guessing IBM will probably invest in the DataStage platform going forward as well, so maybe it will get more programmer friendly with future releases.

    At this point, I don't really have any IT projects to apply this training to, it would be used primarily as a resume builder and to position me as an ETL resource for future projects.


    - 的知 not a spin my wheels type of guy." - Coach Paul Rhoads

  5. #5
    Speechless
    Points: 450,835, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 10.0%
    Achievements:
    SocialRecommendation Second ClassVeteran50000 Experience PointsOverdrive
    brianhos's Avatar
    Join Date
    Jun 2006
    Location
    Trenchtown
    Posts
    39,586
    Points
    450,835
    Level
    100
    Thumbs Up
    Received: 178
    Given: 27

    Re: Any ETL Experts Out There?.....

    We use Oracles warehouse builder. Informatica was a on the list we looked at.


    They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin 1775

  6. #6
    All-Star
    Points: 33,146, Level: 56
    Level completed: 8%, Points required for next Level: 1,104
    Overall activity: 1.0%
    Achievements:
    Veteran25000 Experience Points
    Jonecy's Avatar
    Join Date
    Dec 2006
    Location
    3.5 Hours From Trice
    Posts
    1,264
    Points
    33,146
    Level
    56
    Thumbs Up
    Received: 0
    Given: 0

    Re: Any ETL Experts Out There?.....

    Quote Originally Posted by brianhos View Post
    We use Oracles warehouse builder. Informatica was a on the list we looked at.
    It would be nice to learn some the Oracle tools as well, but unfortunately those aren't supported by my employer, so I don't even have the option (unless I wanted to pay for it myself of course).


    - 的知 not a spin my wheels type of guy." - Coach Paul Rhoads

  7. #7
    Recruit
    Points: 9,283, Level: 28
    Level completed: 89%, Points required for next Level: 67
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points

    Join Date
    Dec 2008
    Location
    Chicago, IL
    Posts
    101
    Points
    9,283
    Level
    28
    Thumbs Up
    Received: 2
    Given: 1

    Re: Any ETL Experts Out There?.....

    Quote Originally Posted by Jonecy View Post
    It would be nice to learn some the Oracle tools as well, but unfortunately those aren't supported by my employer, so I don't even have the option (unless I wanted to pay for it myself of course).

    Are either capable of generating TPS reports?



  8. #8
    All-Star
    Points: 33,146, Level: 56
    Level completed: 8%, Points required for next Level: 1,104
    Overall activity: 1.0%
    Achievements:
    Veteran25000 Experience Points
    Jonecy's Avatar
    Join Date
    Dec 2006
    Location
    3.5 Hours From Trice
    Posts
    1,264
    Points
    33,146
    Level
    56
    Thumbs Up
    Received: 0
    Given: 0

    Re: Any ETL Experts Out There?.....

    Quote Originally Posted by cy616 View Post
    Are either capable of generating TPS reports?
    Did you get the memo?


    - 的知 not a spin my wheels type of guy." - Coach Paul Rhoads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM