Answer Posted / nagam

select count(*),empno from emp group by empno having count(*)>1;

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2167

---

What is size of a transaction and an array means in a datastage?

1243

---

What are routines in datastage?

1269

---

What are the types of jobs we have in datastage?

1024

---

Define repository tables in datastage?

1100

---

Name the different types of Lookups in Datastage?

1214

---

What is a datastage job?

965

---

Define ds designer?

1221

---

What are the various kinds of the hash file?

1098

---

How we can covert server job to a parallel job?

1064

---

What are the functionalities of link partitioner?

974

---

What is the difference between passive stage and active stage?

1412

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

869

---

What are the functionalities of link partitioner and link collector?

952

---

project Steps,hits, Project level HArd things,Solved methods?

2065

---