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


Please Help Members By Posting Answers For Below Questions

How complex jobs are implemented in datstage to improve performance?

580


what is ds administrator used for?

707


Distinguish between informatica & datastage. Which one would you choose and why?

570


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

521


Can you explain kafka connector?

761






What is apt_config in datastage?

689


What are routines in datastage? Enlist various types of routines.

614


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2732


Difference between in process and inter process?

683


What are the some differences between 7.x and 8.x version of datastage?

723


What is the use of hoursfromtime() function in transformer stage in datastage?

574


What are data elements?

645


Define Routines and their types?

608


What are the components of ascential data stage?

636


How to convert RGB Value to Hexadecimal values in datastage?

3442