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/

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

---

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

---

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

---

---

how many write modes are there in ds

2 Answers   IBM,

---

What are some prerequisites for datastage?

0 Answers  

---

Can you filter data in hashed file?

0 Answers  

---

Difference between sequential file and data set?

0 Answers  

---

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

0 Answers  

---

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  

---