Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between datasatge and datastage TX?
- 6 Answers
- 29763 Views
- I also Faced
- E-Mail Answers
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 |
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
Which warehouse using in your datawarehouse
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
What are the components of datastage?
What is ibm datastage flow designer?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
What is the difference between validate and compile?
How many Key we can define in remove duplicate stage?
Define data aggregation?
Teradata 
