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.

On which Dimension Table you implemented SCD Type in your Project

2014

---

Differentiate between data file and descriptor file?

1033

---

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

1064

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1535

---

describe the Steps to confiure a Qlogic switch

2372

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1488

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1484

---

What is the difference between datastage and datastage tx?

1049

---

What is the difference between in process and inter process?

1128

---

What are the types of containers in datastage?

1178

---

What are stage variables, derivations and constants?

1204

---

Differentiate between datastage and informatica?

1171

---

I have a few records just I want to store data in to targets cycling way how?

2341

---

What are the main features of datastage?

1265

---

Can you explain repository tables in datastage?

1388

---