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.

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.

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).

Answer / meena

Datastage is DWH tool and Datastage TX is an EAI tool,
Datastage TX can handle application integration also apart
from data translation.

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

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

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

What is the different type of jobs in datastage?

0 Answers  

What is aggtorec restructure operator?

0 Answers  

How one source columns or rows to be loaded in to two different tables?

0 Answers  

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

0 Answers   UHG,

What are the functionalities of link partitioner?

0 Answers  

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

What are some different alternative commands associated with "dsjob"?

0 Answers  

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

What is the precedence of stage variables,derivations, and constraints?

0 Answers