Answer Posted / dilip anand k

The stage variables are those variables that can be used
and declared on our own inside the transformer stage. These
are accessible only from the transformer stage in which
they are declared.

Any Stage variables we declare are shown in a table in the
right pane of the links area.

Defining the Stage Variable:

Select Insert New Stage variable from the stage variable
shortcut menu. A New variable is added in the table showing
the stage variables in the links area. The default name
given would be StageVar with the default datatype Varchar
(255). These properties can be edited using the Transformer
stage properties dialog box.

To Open the Transformer Stage Properties box
*Click on the stage properties button on the transformer
toolbar.
*Select the stage properties from the shortcut menu
*Select Stage variable properties from the stage variable
shortcut menu

The Properties box contains the Variable Name, Initial
Value, SQL data type, Precision, Scaling and Description
(optional).

Edit the variable as required and Click OK.

What are the types of views in datastage director?

1244

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

657

---

What is the difference between hashfile and sequential file?

716

---

What is the command line function to import and export the ds jobs?

679

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2424

---

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

953

---

Where the datastage stored his repository?

616

---

How and where you used hash file?

655

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1463

---

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2187

---

What are transforms and what is the differenece between routines and transforms?

611

---

What are sequencers?

616

---

Which warehouse using in your datawarehouse

1680

---

What is the difference between server job and parallel jobs?

662

---

What is job control?

622

---