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 you can fix the truncated data error in datastage?
What is the differentiate between data file and descriptor file?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the steps required to kill the job in Datastage?
What are the differences between datastage and informatica?
What are iconv and oconv?
Define ds designer?
Define data aggregation?
What are the main features of datastage?
What steps should be taken to improve Datastage jobs?
Describe stream connector?
Explain connectivity between datastage with datasources?
how to export or import the jobs in .ISX file
What are stage variables, derivations and constants?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?