Tell me Wt main advantage of Stage varibles?
Project level hints?
Answer Posted / pavan
The simple meaning of a stage variable is just like a
global variable.During processing the execution starts with
stage variables then contraints and then to individual
columns.If ever there is a prerequsite formulae which can
be used by both contraints and also individual columns then
we can define it in stage varaibles so that it can be
processed once and can be used by multiple records.If ever
we require the formulae to be modified for each and every
row then it is advisable to place in code in record level
than stage variable level
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are stage variables and constants?
how to implement scd2 in datastage 7.5 with lookup stage
Is possible to create skid in dim,fact tables?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the roundrobin collector?
How do you reject records in a transformer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the sortmerge collector?
what is the use of surogate key in datastage
What are the components of datastage?
How and where you used hash file?
How complex jobs are implemented in datstage to improve performance?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Is it possible to query a hash file?