Answer Posted / subbuchamala

SRC--> COPY stage--> 2 o/p links from COPY Stage-->
one is --> AGGREGATOR and other is --> JOIN-->TGT

-->In AGG Stage:
set group=DEPNO
aggregator type=calculation
column for calculation=SAL
max value output column=SAL

-->O/P of AGG Stage:
SAL(max(sal), DEPNO

-->In JOIN stage:
Inner Join on DEPNO and SAL and get the EMPNO as well.
By doing this, we get Max(sal) of the employee on particular DEPNO.

How the ipc stage work?

1130

---

what is the use of materialized view?

1572

---

How to reverse the string using unix?

3510

---

How to perform incremental load in datastage?

1203

---

Which algorithm you used for your hashfile?

1183

---

what is the use of skid in reporting?

2381

---

Explain entity, attribute and relationship in datastage?

1105

---

What are the types of views in datastage director?

1775

---

How to read multiple files using a single datastage job if files have the same metadata?

1252

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2064

---

how to abort the job its matain duplicates?

2574

---

What is apt_config in datastage?

1140

---

why do u need the IOS upgradation in a FC switch

2283

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2814

---

What is quality stage?

988

---