Answer Posted / venkatesh.m

we can't use round robin for aggrigator
Because round robin shares the records equally to all the
nodes.
but if it goes like that there may be a chance to get not
relevant o/p (UN expected o/p )

its better to use hash partition



if am wrong plz let me know

Differentiate between hash file and sequential file?

1083

---

Differentiate between validated and Compiled in the Datastage?

1291

---

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

1097

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2243

---

Describe routines in datastage? Enlist various types of routines.

1017

---

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

2289

---

Demonstrate experience in maintaining quality process standards?

2565

---

On which interface you will be working as a developer?

1057

---

Define repository tables in datastage?

1167

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2510

---

What is datastage engine?

1186

---

What is meta stage?

1189

---

What is merge stage?

1323

---

Name the different sorting methods in datastage.

1064

---

What are the different kinds of views available in a datastage director?

1036

---