Answer / kpk

Environmental Variables can be declared / create in the
DataStage Administrator. In ds admin click on Environmental
variables and select user defined. there you will be able to
define your environmental variable.

Answer / viji

We can call the environmental variable by using job properties tab of sequence and parallel datastage jobs

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

0 Answers   HCL,

---

What is the default execution order of the sequential file?

3 Answers  

---

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

---

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

---

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

---

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

5 Answers   Genpact,

---

what is sparse lookup?

7 Answers   IBM,

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

0 Answers  

---