Answer / prasad

i think there is no function on rank , you can write a sql
query for that one in oracle stage or drs stage/

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

Describe link sort?

0 Answers  

---

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

0 Answers  

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,

---

What is staging variable?

0 Answers  

---

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  

---

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers  

---

Explain the ChangeApply stage?

11 Answers  

---

what is a message handler

3 Answers   IBM,

---

convert yyyy mm dd to dd mm yyyy?

4 Answers  

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---