Tell me Wt main advantage of Stage varibles?
Project level hints?
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 ? | 11 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 |
Why we need datasets ratherthan sequential files?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
What are routines in datastage? Enlist various types of routines.
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the differentiate between data file and descriptor file?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
which unix commands mostly used in datastage
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?