Answer Posted / akila

In case an explicit sort stage is used like inteh reply
above, the sort will be done on emp_id(key field) and the
salary. But remove duplicate will be done only on emp_id. I
guess that this might result in a warning like 'sort and
remove duplicates keys do not match'.

Differentiate between Join, Merge and Lookup stage?

1056

---

How do you import and export data into datastage?

1197

---

What a datastage macro?

1023

---

describe the Steps to confiure a Qlogic switch

2348

---

options available in sequence job to run,validate?

1273

---

What is the method of removing duplicates, without the remove duplicate stage?

985

---

Why do we use link partitioner and link collector in datastage?

1100

---

Describe the main features of datastage?

1053

---

How a routine is called in datastage job?

1061

---

Is possible to create skid in dim,fact tables?

2604

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2154

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2165

---

How complex jobs are implemented in datstage to improve performance?

992

---

What are the different layers in the information server architecture?

1099

---

What are orabulk and bcp stages?

1086

---