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.

Could anyone give brief explanation bout datastage admin

2408

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2079

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1135

---

What is the difference between Datastage 7.5 and 7.0?

1154

---

Can you explain engine tier in information server?

1191

---

What is orabulk stage?

1109

---

Is it possible to query a hash file?

2062

---

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?

2266

---

How many Key we can define in remove duplicate stage?

1448

---

Where do you see different stages in the designer?

1148

---

What are stage variables, derivations and constants?

1285

---

How to Remove Duplicate using SQL?

1428

---

What are the primary usages of datastage tool?

1136

---

Define data aggregation?

1153

---

Differentiate between validated and Compiled in the Datastage?

1357

---