Answer / ankit gosain

Hi All,

Hash partitioning is more expensive than modulus but it'll
give better performance as well.
The basic difference is, you can apply Modulus partitioning
for the number fields only while you can apply Hash
partitioning for Varchar and any type of field.

If you have more queries, you can mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

Answer / nish

has partitioning when distinct key fields are less.

Modulus when the key field are very few and numeric.

Modulus = x%y so the field ought to be numeric

I have 100 records how can I load at a time from the single time

1 Answers  

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---

What are the types of jobs we have in datastage?

0 Answers  

---

options available in sequence job to run,validate?

0 Answers   CTS,

---

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  

---

Why fact table is in normal form?

0 Answers  

---

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

---

Name the different sorting methods in datastage.

0 Answers  

---

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 can we achive parallelism

1 Answers   CTS,

---