chanakya

• Feb 11th, 2006

 

The main difference between data stge and informatica is the SCALABILTY..informatca is scalable than datastage

Surya

• Feb 16th, 2006

 

In my view Datastage is also Scalable, the difference lies in the number of built-in functions which makes DataStage more user friendly

Sharanu Patil

• Feb 28th, 2006

 

In my view,Datastage is having less no. of transformers copared to Informatica which makes user to get difficulties while working

satheesh_color

 Profile Answers by satheesh_color 

• Mar 9th, 2006

 

The main difference is Vendors. Each one is having plus from their architecture. For Datastage it is a Top-Down approach. Based on the Businees needs we have to choose products.

Umaski

• May 2nd, 2006

 

Main difference lies in parellism, Datastage uses parellism concept through node configuration, where Informatica does not 

Anjan Roy

• Nov 27th, 2006

 

I have used both Datastage and Informatica... In my opinion, DataStage is way more powerful and scalable than Informatica. Informatica has more developer-friendly features, but when it comes to scalabality in performance, it is much inferior as compared to datastage.

Here are a few areas where Informatica is inferior -

1. Partitioning - Datastage PX provides many more robust partitioning options than informatica. You can also re-partition the data whichever way you want.

2. Parallelism - Informatica does not support full pipeline parallelism (although it claims).

3. File Lookup - Informatica supports flat file lookup, but the caching is horrible. DataStage supports hash files, lookup filesets, datasets for much more efficient lookup.

4. Merge/Funnel - Datastage has a very rich functionality of merging or funnelling the streams. In Informatica the only way is to do a Union, which by the way is always a Union-all.

Satish Karbhari

• Jun 29th, 2007

 

Hi Sharanu,

Can you give the specific scenario where you are facing difficulty with Data stage.
Less no. of Transformers? Can you tell me which one is missing?

Thanks,
Satish

Mohan Krishnan Mannam

• Jul 5th, 2007

 

Informatica and DataStage both are ETL tools, which are used for data acquisition process, Nothing but ETL the main difference between Informatica and DataStage is for Informatica the repository (container of meta data  is database-meta data is stored in database for data stage the repository is file-meta data is stored in file before going to ETL Informatica & DataStage will check the repository for meta data here accessing a file is more faster than database because file is static but data is more secure in data base than file-data may be corrupted in file hence finally we can conclude that data stage will perform faster than Informatica but when it comes to security issue Informatica is better than DataStage

sunrays_arun

 Profile Answers by sunrays_arun 

• Oct 26th, 2007

 

SAS DI studio is best when compared to Informatica and Datastage as it generates SAS code at the back end .SAS is highly flexible compared to other BI solution.

pundlik

• Sep 5th, 2014

 

Compared to Informatica the Data Stage is more User friendly