Answer / kpk

to initialize environmental variables goto DS Admin, click
on environmental variable button. then proceed to user
defined.. there u will be able to provide user defined EV's.

you need to define the values in the DS admin, and you can
call them in the DS job parameter using the magic word
"PROJDEF".

Answer / archana

First u can initialize env variables in datastage administrator,then click on Environmental variable button,Next write whatever u defined(server,username,pwd).
next open ds designer u can call those environmental variables in this designer by using job parameter window

Answer / chenna

what is difference between the changecaputer stage and
difference stage?

Answer / sowmiya

what is difference between the changecaputer stage and
difference stage?

changecaputer stage provide the data only for after link .
Difference stage given the value of the before and after link.

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

---

What is the difference between passive stage and active stage?

0 Answers  

---

What is the difference between odbc and drs stage?

0 Answers  

---

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

---

In merge stage can we update the values?

3 Answers   TCS,

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

How do you remove duplicate values in datastage?

0 Answers  

---

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

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 hash file

2 Answers   CTS, IBM,

---

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

---