Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between datasatge and datastage TX?
- 6 Answers
- 30025 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 |
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
How do y read Sequential file from job control?
What are the functionalities of link collector?
What are the different kinds of views available in a datastage director?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Define Merge?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
Wat is isolation level and when do u use them?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
what is 'reconsideration error' and how can i respond to this error and how to debug this
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
What is the use of datastage director?
Teradata 
