Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me Wt main advantage of Stage varibles?
Project level hints?
- 4 Answers
- 14751 Views
- Hexaware, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramjanaki
The main advantage of Stage Variables is to reduce the
repetition of the code for all the required columns in the
Transformer.
Say for Example, if you are having 10 lines of code to
be used for all the derivations of columns in the
transformer, we declare a Stage variable once and we assign
these 10 lines of code to that variable and can place this
Stage variable where ever needed in the derivation of the
columns in the Transformer Stage. Th scope of these
variables is limited with in the stage it is created.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / 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 |
Answer / brajesh
1. it can be used as global variable
2. It can be used for some preproceesiing operation
required for some constarint or records(columns).
3.It can be used to store the previous rows processed data
which can be used by next coming row.( its one of the
programming tactic )
Also the order of stage variable matters , it will execute
in the order they apeared on its palate.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / giri
The advantage of stage variables mainly used for
manipulation purpose.
| Is This Answer Correct ? | 0 Yes | 4 No |
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
How to add zero "0" before record in a field?
how to identifie,is it innerjoin,leftouter join in lookup?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
what is flow of project?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
How can we improve the performance in datastage?
Teradata 
