Answer Posted / chowdary

in sequntial file options filter--> sort | uniq -d
this will give best performence to remove duplicates.

What is difference between symmetric multiprocessing and massive parallel processing?

1134

---

Highlight the main features of datastage?

1157

---

What are the steps required to kill the job in Datastage?

1214

---

What is the importance of the exception activity in datastage?

1064

---

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)

917

---

How to Remove Duplicate using SQL?

1360

---

What steps should be taken to improve Datastage jobs?

1063

---

Difference between data warehousing and olap?

1089

---

Which algorithm you used for your hashfile?

1175

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

800

---

What are the functionalities of link partitioner?

1013

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1502

---

Define orabulk and bcp stages?

1119

---

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?

2173

---

Have you used Unstructured data?

1314

---