Answer / ramesh

any number of columns we can perform aggregation
ex:group by deptno,group by deptname,

Answer / devendra singh

any no of columns we can aggregate in aggregation stage

Answer / kiran

Depends upon Requirement....u can apply aggregations

What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

Describe stream connector?

0 Answers  

---

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  

---

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

---

How rejected rows are managed in datastage?

0 Answers  

---