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.

Describe stream connector?

919

---

What are system variables and sequencers in datastage

692

---

How do you import and export the datastage jobs?

825

---

How many types of stage?

788

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

850

---

---

Name the third party tools that can be used in datastage?

715

---

What are data elements?

754

---

What is the command line function to import and export the ds jobs?

780

---

What is a quality stage in datastage tool?

712

---

Define meta stage?

873

---

why do u need the IOS upgradation in a FC switch

1958

---

Define APT_CONFIG in Datastage?

746

---

Nls stands for what in datastage?

833

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1741

---

What is the difference between an operational datastage and a data warehouse?

734

---