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

Have you used Unstructured data?

1303

---

Differentiate between datastage and datastage tx?

1040

---

What is the difference between informatica and datastage?

1203

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1265

---

How do you import and export the datastage jobs?

1146

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2881

---

What are orabulk and bcp stages?

1110

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3740

---

What are the processing stages?

1085

---

How many types of views are there in a datastage director?

1272

---

What are the different types of lookups in datastage?

1047

---

Why we use surrogate key?

1208

---

What are the steps needed to create a simple basic datastage job?

1218

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2076

---

What is the difference between operational data stage (ods) and data warehouse?

1224

---