Answer Posted / sag

so kiran,iam not hving idea viewers plz respond kiran's
requirement


sag

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

725

---

What are routines in datastage?

1263

---

table actions available in oracle connector?

1553

---

EXPLAIN SCD

1336

---

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?

2128

---

What is the method of removing duplicates, without the remove duplicate stage?

954

---

Does datastage support slowly changing dimensions ?

1053

---

What are the different options associated with dsjob command?

1370

---

What is the difference between account and directory options ?

1109

---

how to abort the job its matain duplicates?

2531

---

in oracle target stage when we use load option and when we use upsert option?

2200

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

863

---

Describe link sort?

959

---

How and where you used hash file?

1106

---

Explain how a source file is populated?

1308

---