Answer Posted / poornachandrababu.l

Hi, This is Poorna,
take a source and then copy stage,to copy stage 2 o/p links
one output is for aggregator and other for join.

In aggregator
set group=deptno
aggregator type=calculation
column for calculation=sal
max value output column=sal.

In Join stage do equee join based on deptno and sal .

And pass output of join Stage to target.
By doing this wasy we can get Max(sal) of the employee on
particular department.

Differentiate between datastage and informatica?

1246

---

What is datastage?

1130

---

what is ds administrator used for?

1215

---

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

2182

---

What could be a data source system?

1096

---

What are the types of containers?

1310

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3519

---

What is the differentiate between data file and descriptor file?

1410

---

Can you explain engine tier in information server?

1181

---

What a datastage macro?

1101

---

How we can covert server job to a parallel job?

1256

---

Difference between data warehousing and olap?

1139

---

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

1073

---

What are some different alternative commands associated with "dsjob"?

1208

---

What are the steps required to kill the job in Datastage?

1264

---