Difference between data warehousing and olap?

0 Answers  

---

What is use Array size in datastage

0 Answers  

---

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,

---

what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,

---

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

---

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

---

what is main difference between change capture and change apply stages

4 Answers   IBM,

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

How to create user defined environment varibale(parameter)?

1 Answers   TCS,

---

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

---