Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Tell me Wt main advantage of Stage varibles?
Project level hints?

Answers were Sorted based on User's Feedback



Tell me Wt main advantage of Stage varibles? Project level hints?..

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

Tell me Wt main advantage of Stage varibles? Project level hints?..

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 ?    4 Yes 2 No

Tell me Wt main advantage of Stage varibles? Project level hints?..

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

Tell me Wt main advantage of Stage varibles? Project level hints?..

Answer / giri

The advantage of stage variables mainly used for
manipulation purpose.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer



More Data Stage Interview Questions

What is a quality stage?

0 Answers  


What is the use of datastage director?

0 Answers  


Explain the functionality of your current project?

1 Answers   IBM, Miles Software,


What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,


Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  






How to initialize environment variables?

4 Answers   Infosys,


WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,


How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,


If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,


Where do you see different stages in the designer?

0 Answers  


Define data aggregation?

0 Answers  


what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,






Categories