Advantage of Datastage over Informatica
Moderators: chulett, rschirm, roy
Advantage of Datastage over Informatica
Hai All,
Iam new to datastage. I would like to know 3 or more characteristics you like about DataStage over Informatica.
Regards
Cherry
Iam new to datastage. I would like to know 3 or more characteristics you like about DataStage over Informatica.
Regards
Cherry
Cherry,
a question phrased that way sounds so much like an interview question that those who have used both product will probably not be interested in responding. Why not state why you are looking for answers to this question and be satisfied with just one reason?
The answer is so judgemental as well and is like asking for a choice between Microsoft and Linux - or between Catholicism and Protestant.
I prefer DataStage over Informatica because the BASIC language in DS makes quick coding possible even for those without a foundation in C++.
a question phrased that way sounds so much like an interview question that those who have used both product will probably not be interested in responding. Why not state why you are looking for answers to this question and be satisfied with just one reason?
The answer is so judgemental as well and is like asking for a choice between Microsoft and Linux - or between Catholicism and Protestant.
I prefer DataStage over Informatica because the BASIC language in DS makes quick coding possible even for those without a foundation in C++.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
DataStage has a better splash screen, DataStage is easier to say while you are holding your tongue and DataStage rhymes with MetaStage, ProfileStage and QualityStage. I think you'll find Informatica rhymes with none of those products.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Hi
1. Cost (datastage is cheaper then informatica)
2. Parallel Processing ( Works well in Unix)
3. IBM brand name
Thanks
Sanjay
1. Cost (datastage is cheaper then informatica)
2. Parallel Processing ( Works well in Unix)
3. IBM brand name
Thanks
Sanjay
ArndW wrote:Cherry,
a question phrased that way sounds so much like an interview question that those who have used both product will probably not be interested in responding. Why not state why you are looking for answers to this question and be satisfied with just one reason?
The answer is so judgemental as well and is like asking for a choice between Microsoft and Linux - or between Catholicism and Protestant.
I prefer DataStage over Informatica because the BASIC language in DS makes quick coding possible even for those without a foundation in C++.
Please differentiate Server, PX, RTI, etc and their versions.
The war stories for each is vastly different, as well as their successes.
The war stories for each is vastly different, as well as their successes.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Server has an exquisite integrated Debugger that has been there from the beginning. Be sure which flavour of the tool you're addressing.koolnitz wrote:I wish DataStage had DEBUGGER, as we have this feature inbuilt in Informatica..
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 37
- Joined: Sun Aug 01, 2004 1:18 am
Re: Advantage of Datastage over Informatica
Hi,
We don't need any other database for creating repository. DataStage has its own DB (UniVerse).
We don't need to import table def for Sources and targets seperately.
We don't need to create sessions,... then workflos... then worklets.. then workflows.... in different windows....
We don't need to so many exp_transformations to convert data...
We don't need filter transformations to impose any constraints... we can do it in transformer.
We don't need to create in put ports and output ports...
and so ... so... many like this...
We don't need any other database for creating repository. DataStage has its own DB (UniVerse).
We don't need to import table def for Sources and targets seperately.
We don't need to create sessions,... then workflos... then worklets.. then workflows.... in different windows....
We don't need to so many exp_transformations to convert data...
We don't need filter transformations to impose any constraints... we can do it in transformer.
We don't need to create in put ports and output ports...
and so ... so... many like this...
Thanks,
Cnu
We work together to workout...
Cnu
We work together to workout...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Isn't there a Metabroker that allows MetaStage to get stuff from Informatica?vmcburney wrote:DataStage has a better splash screen, DataStage is easier to say while you are holding your tongue and DataStage rhymes with MetaStage, ProfileStage and QualityStage. I think you'll find Informatica rhymes with none of those products.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Each tool is a good tool. Each tool is in Gartner's top right quadrant. They involve a different mind set during design (simplified as top-down versus bottom-up) but should end up with the same solution from the same plan. Any person may prefer one over the other. Here you're likely to get a bias towards DataStage (it's a DataStage place) - on an Informatica forum the bias is likely to be the other way.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 37
- Joined: Sun Aug 01, 2004 1:18 am
Nice Endup....ray.wurlod wrote:Each tool is a good tool. Each tool is in Gartner's top right quadrant. They involve a different mind set during design (simplified as top-down versus bottom-up) but should end up with the same solution from the same plan. Any person may prefer one over the other. Here you're likely to get a bias towards DataStage (it's a DataStage place) - on an Informatica forum the bias is likely to be the other way.
Thanks,
Cnu
We work together to workout...
Cnu
We work together to workout...
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Some interesting points made in this thread. There were a few threads on this topic over at www.datawarehouse.com, back when it was popular, and whenever one person stated the advantages of one product over the other someone else was able to dispute each point. As Ray points out they are in almost exactly the same place on the Garnter quadrant and they overlap in ETL, data quality and metadata.
I like the comparisons of ETL versus ELT (eg. Sunopsis) versus DBMS ETL (OWB and SQL Server ETL) versus BI ETL (BO and Cognos) versus ERP ETL (Oracle Data Hub, SAP Netweaver). The choice between Informatica and DataStage is almost irrelevent, you just play them against each other to get a better price, but the big choice is whether you want pure play ETL or whether you are looking for a cheaper option or something that bundles with an existing product.
I like the comparisons of ETL versus ELT (eg. Sunopsis) versus DBMS ETL (OWB and SQL Server ETL) versus BI ETL (BO and Cognos) versus ERP ETL (Oracle Data Hub, SAP Netweaver). The choice between Informatica and DataStage is almost irrelevent, you just play them against each other to get a better price, but the big choice is whether you want pure play ETL or whether you are looking for a cheaper option or something that bundles with an existing product.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn