Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me Wt main advantage of Stage varibles?
Project level hints?
- 4 Answers
- 14592 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 |
What is the difference between hashfile and sequential file?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
source file is having 5 records while moving into target it want to be 10 records
What are the processing stages?
What are the components of ascential data stage?
how many write modes are there in ds
i have the source from Uk,north america how can i pass the data two tables based on the locations
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
What are orabulk and bcp stages?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Teradata 
