Hi Guys,
The datastage for Datawarehousing and datastage TX are two different product with the same name or it the same tool used in DWH as well as EAI.
Regards,
Arvind
Difference between DWH Datastage and Datastage TX
-
- Participant
- Posts: 5
- Joined: Wed Aug 23, 2006 9:37 am
Difference between DWH Datastage and Datastage TX
Arvind Maurya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no such thing as "DataStage for DataWarehousing".
There are four separate products. What they have in common is that they all perform extraction, transformation and loading (ETL). The target does not need to be a data warehouse for any of them.
There are four separate products. What they have in common is that they all perform extraction, transformation and loading (ETL). The target does not need to be a data warehouse for any of them.
- DataStage server
DataStage parallel
DataStage mainframe
DataStage transformation extender (TX)
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.
You can find the list of product classified under IBM's website.
http://ibm.ascential.com/products/
http://ibm.ascential.com/products/
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I think DataStage jobs are far more common than TX jobs. For example on an Australian job site I see 113 ads with DataStage in the job description and 4 with TX or Mercator (the old name for TX). This means if you are an expert in TX you could potential earn the most money since resouces are hard to find, but you could face a longer wait between contracts. If you are a TX beginner it could be much harder finding work.
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
Are you looking for a tool or consult?
I'd put the most emphasis on what it is you want to do. While all of the tools perform data transformation each has a different strengths.
DataStage is probably a better tool if you are running batch operations and are working with large amounts of data tied to databases.
DataStage TX will work with a broad variety of databases but is much less efficient when loading large files to tables. Not sure there's much diff in data extracts.
Both are very good when it come to confirming data integrity.
TX is probably better when it comes to working with edi/x12 formats and has have a nice HIPAA package.
I'd put the most emphasis on what it is you want to do. While all of the tools perform data transformation each has a different strengths.
DataStage is probably a better tool if you are running batch operations and are working with large amounts of data tied to databases.
DataStage TX will work with a broad variety of databases but is much less efficient when loading large files to tables. Not sure there's much diff in data extracts.
Both are very good when it come to confirming data integrity.
TX is probably better when it comes to working with edi/x12 formats and has have a nice HIPAA package.
-
- Participant
- Posts: 1
- Joined: Wed Oct 18, 2006 3:04 am