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

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

---

What is quality stage?

0 Answers  

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

Describe stream connector?

0 Answers  

---

In merge stage can we update the values?

3 Answers   TCS,

---

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

---

how do u reduce warnings

1 Answers   CGI,

---

Pls tell me what is troubleshooting in datastage view?

1 Answers  

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

What a datastage macro?

0 Answers  

---

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---