Answer Posted / hari

Hash partitioning
method is the key
based partition
method... And lookup
wich also compare and
retrieve the data
based on key
column... So by using
hash method wil
increase performance
in lookup...

What are the main differences you have observed between 7.x and 8.x version of datastage?

1072

---

What is aggtorec restructure operator?

1427

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2602

---

What are constraints and derivations?

1151

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2089

---

How to read the length of word in unix?

1367

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2142

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2277

---

How to Remove Duplicate using SQL?

1341

---

what is the use of surogate key in datastage

2296

---

What are the different common services in datastage?

1269

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2042

---

What is size of a transaction and an array means in a datastage?

1287

---

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?

2167

---

What is difference between symmetric multiprocessing and massive parallel processing?

1124

---