DataStage - what is the difference between datastage and informatica

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 142 of 374

what is the difference between datastage and informatica

Total Answers and Comments: 9

Last Update: October 26, 2007 Asked by: anunath

Sponsored Links

Best Rated Answer

—

Submitted by: Anjan Roy

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.

Above answer was rated as good by the following members:
jayadev.dwh, manoharkolukula

February 11, 2006 08:17:36

chanakya

RE: what is the difference between datastage and infor...

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

February 16, 2006 02:14:34

Surya

RE: what is the difference between datastage and infor...

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

February 28, 2006 01:29:56

Sharanu Patil

RE: what is the difference between datastage and infor...

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

March 09, 2006 03:58:34

satheesh_color

Member Since: March 2006 Contribution: 8

RE: what is the difference between datastage and infor...

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.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

May 02, 2006 02:18:46

Umaski

RE: what is the difference between datastage and infor...

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

November 27, 2006 19:59:48

Anjan Roy

RE: what is the difference between datastage and infor...

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

June 29, 2007 01:23:20

Satish Karbhari

RE: what is the difference between datastage and infor...

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

July 05, 2007 06:42:02

Mohan Krishnan Mannam

what is the difference between datastage and infor...

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

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

October 26, 2007 05:20:20

sunrays_arun

Member Since: October 2007 Contribution: 1

RE: what is the difference between datastage and infor...

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top