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.

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1297

---

how to delete one row in target dataset

3065

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1333

---

Define repository tables in datastage?

1100

---

What is quality stage?

937

---

How do you reject records in a transformer?

1061

---

Which algorithm you used for your hashfile?

1121

---

Can you explain engine tier in information server?

1063

---

Explain how a source file is populated?

1316

---

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

1025

---

How will you move hashed file from one location to another location?

2096

---

How to Remove Duplicate using SQL?

1294

---

How can one find bugs in job sequence?

1319

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2750

---

what is the use of materialized view?

1489

---