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 |
what is initial load and incremental load
Explain briefly scd type2 in datastage7.5x2(parallel)
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
Differentiate between datastage and datastage tx?
1)Source file contains one record, I want 100 records in target file.
What are the types of containers in datastage?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
What is the purpose of pivot stage?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?