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
How complex jobs are implemented in datstage to improve performance?
what is ds administrator used for?
Distinguish between informatica & datastage. Which one would you choose and why?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Can you explain kafka connector?
What is apt_config in datastage?
What are routines in datastage? Enlist various types of routines.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Difference between in process and inter process?
What are the some differences between 7.x and 8.x version of datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are data elements?
Define Routines and their types?
What are the components of ascential data stage?
How to convert RGB Value to Hexadecimal values in datastage?