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.

Name the different types of Lookups in Datastage?

718

---

table actions available in oracle connector?

1084

---

Can you explain kafka connector?

768

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

541

---

Which warehouse using in your datawarehouse

1675

---

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2419

---

Explain ibm infosphere information server and highlight its main features?

600

---

What are the processing stages?

636

---

Why do we use exception activity in Datastage?

705

---

How we can covert server job to a parallel job?

591

---

How many Key we can define in remove duplicate stage?

816

---

What is a folder? Difference types of stages?

617

---

Why fact table is in normal form?

666

---

What is aggtorec restructure operator?

711

---

Define meta stage?

773

---