Interested to Buy Any Domain ? << Click Here >> for more details...
1)What is ur project architecture ?
2)how to move project from developement to uat?
3)What is the difference between datastage 6,7.1 and
datasttage 7.5?
4).How to do error handling in datastage?
5)3.Whta is unit testing, system testing and integration
testing?
6)What is the Exact difference between BASIC Transformer
and NORMAL Transformer?When we will go for BASIC Or NORMAL
Transformer
7)why we use third party tools in datastage?
8)What is the purpose of Debugging stages? In real time
Where we will use?
- 6 Answers
- 32131 Views
- CTS, HCL, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ramya
Answer for 6th question.
1. The Transformer stage is inherent PX functionality,
whereas the BASIC Transformer uses a Server interface to
call a Server Transformer stage. There's severe performance
impact as well as partitioning limitations, but it does
give a PX job some access to existing Server functionality.
2. There ate two types of transformer i. Basic
transformer and ii. Active transformer. Basic transformer
is used for SMP system and not in MPP or cluster. Basic
transformer (BASIC is the language supported by the Data
stage server engine and available in Server job). Where in
Datastage Px the Active transformer get use.
3. Transformer stages are always active stages. The
basic transform stage is part of the Server product, but
the PX engine allows this stage to be called (the opposite,
using a PX stage in Server is not possible)
4.
In parallel jobs there are two, very different, stage
types. One is called the Transfomer stage, the other is
called the BASIC Transformer stage.
Parallel jobs do not use the DataStage BASIC run machine;
instead they use a C-based environment that is/was called
osh (from "Orchestrate shell", Orchestrate being the
original name for the parallel execution environment
acquired by Ascential by purchasing Torrent).
This is why the Transformer stage in parallel jobs does not
use BASIC. The BASIC language not supported in osh .
The BASIC Transformer stage in parallel jobs causes osh to
invoke the DataStage BASIC run machine for the stage to be
executed. This obviously is an extra overhead.
5. The Transformer stage in parallel jobs can NOT access
BASIC functions, etc. It uses a completely different
expression editor, with a largely equivalent list of
operators, and a different, though overlapping, list of
functions and other operands (but they're not BASIC
functions and operators).
The BASIC Transformer stage in parallel jobs is a direct
equivalent of the Transformer stage in server jobs. Its use
will carry a performance overhead, because the BASIC run
machine will also need to be loaded when the parallel job
is executed. But the convenience might well override this
consideration, particularly given the richness of the
function set in BASIC
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How a routine is called in datastage job?
Explain connectivity between datastage with datasources?
Where do you see different stages in the designer?
What are iconv and oconv?
What are sequencers?
how to implement scd2 in datastage 7.5 with lookup stage
What is difference between symmetric multiprocessing and massive parallel processing?
How can we improve the performance in datastage?
how to write server Routine coding?
Define Merge?
sed,awk,head
How to convert RGB Value to Hexadecimal values in datastage?
Where the datastage stored his repository?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is datastage?
