Answer Posted / 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

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2139

---

What are the types of containers?

1151

---

Notification Activity

1358

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1179

---

What are the various kinds of the hash file?

1104

---

Differentiate between data file and descriptor file?

997

---

How we can covert server job to a parallel job?

1070

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

734

---

What are the different kinds of views available in a datastage director?

983

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

956

---

Can we use target hash file as a lookup ?

3274

---

What are the areas of application?

1101

---

Does datastage support slowly changing dimensions ?

1063

---

What is datastage engine?

1130

---

what are the errors,warnings in datastage

2630

---