Advantage of Datastage over Informatica

cherry · Post by **cherry** » Mon Dec 19, 2005 1:37 am

Hai All,

Iam new to datastage. I would like to know 3 or more characteristics you like about DataStage over Informatica.

Regards
Cherry

ArndW · Post by **ArndW** » Mon Dec 19, 2005 1:49 am

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

vmcburney · Post by **vmcburney** » Mon Dec 19, 2005 2:11 am

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.

sanjay · Post by **sanjay** » Mon Dec 19, 2005 2:12 am

Hi

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

kduke · Post by **kduke** » Mon Dec 19, 2005 6:32 am

The answer is so judgemental

The best answer might be that SAP, PeopleSoft and some of the biggest software companies use DataStage and include it with their products. If it was not at least as good then why would they switch from the other to DataStage.

kcbland · Post by **kcbland** » Mon Dec 19, 2005 9:01 am

Please differentiate Server, PX, RTI, etc and their versions.

The war stories for each is vastly different, as well as their successes.

koolnitz · Post by **koolnitz** » Mon Dec 19, 2005 9:25 am

I wish DataStage had DEBUGGER, as we have this feature inbuilt in Informatica..

kcbland · Post by **kcbland** » Mon Dec 19, 2005 9:32 am

koolnitz wrote:I wish DataStage had DEBUGGER, as we have this feature inbuilt in Informatica..

Server has an exquisite integrated Debugger that has been there from the beginning. Be sure which flavour of the tool you're addressing.

DataStageCnu · Post by **DataStageCnu** » Mon Dec 19, 2005 10:30 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Dec 19, 2005 1:56 pm

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.

Isn't there a Metabroker that allows MetaStage to get stuff from Informatica?

ray.wurlod · Post by **ray.wurlod** » Mon Dec 19, 2005 2:00 pm

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.

DataStageCnu · Post by **DataStageCnu** » Mon Dec 19, 2005 2:13 pm

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.

Nice Endup....

vmcburney · Post by **vmcburney** » Mon Dec 19, 2005 4:21 pm

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.

cherry · Post by **cherry** » Tue Dec 20, 2005 12:35 am

Hai All,

Thanks for all who spent their valuable time on this topic.

Regards
Cherry

DSXchange

Advantage of Datastage over Informatica

Advantage of Datastage over Informatica

Re: Advantage of Datastage over Informatica