what is the difference between datasatge and datastage TX?
Answers were Sorted based on User's Feedback
Answer / ram
I Think vipul is near to the answer.
DataStage is an ETL tool Datastage TX is an EAI tool.
Datastage used in DWH ,TX used in EDI(Entrprise Data
Interchange). The application of both tools is vary from
both.
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / shashiall
This is not the correct answer Msuri...b'coz question in
datastage TX...that is complete different from Datastage PX
and SERVER.
So,Datastage TX is ...basically deals with Transformation
part ..this is not a pure ETL tool...It does not involved
in Extraction And Loading....Deals only in Transformation.
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / amrutha
Ram is 100% correct...
DataStage is an ETL tool that is related to DW/BI
(Datawarehousing and Business Intelligence), where as
DataStage TX is an EAI tool that is related to Integration
(A2A / B2B).
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / meena
Datastage is DWH tool and Datastage TX is an EAI tool,
Datastage TX can handle application integration also apart
from data translation.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vipul
IBM Websphere Datastage has series of ETL tools which
SERVES EXTRACTION , TRANSFORMATION and LOADING needs.
1. IBM DATASTAGE TX is the Any to Any message
Transformation tool. It accepts message of any format (
xml, fixed length ) and can convert it to any desired
format.
2 .IBM DATASTAGE PX is completely different.. checkout on
http://www-306.ibm.com/software/info1/websphere/index.jsp?
tab=products/enterprisetransformation
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / msuri
I think its difference between server and parallel jobs
Here is the diff
Server jobs. These are available if you have installed
DataStage Server. They run on the DataStage Server,
connecting to other data sources as necessary.
These are compiled and run on DataStage Server
Parallel jobs. These are only available if you have
installed Enterprise Edition. These run on DataStage
servers that are SMP, MPP, or cluster systems. They can
also run on a separate z/OS (USS) machine if required.
These are available only if you have Enterprise Edition
installed.
These are compiled and run on a DataStage Unix Server
Is This Answer Correct ? | 3 Yes | 14 No |
where the log files or tables can store in DS?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
why we use hash file for lookup?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
In merge stage can we update the values?
what is .dsx files
How to display all the duplicate records from the oracle Table?
Explain ibm infosphere information server and highlight its main features?
What is mapping?
how to handle null values in sequential file?