Answer / rajesh.dwh

Function must returns value, but Procedure may or may not
return value.
Function can be use with select statement where Procedure
can't be used with select statement regarding ORACLE SELECT
statement.

What is 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,

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

---

Define meta stage?

0 Answers  

---

How can we improve performance of data stage jobs?

0 Answers  

---

---

How do you register plug-ins?

0 Answers  

---

How can we achive parallelism

1 Answers   CTS,

---

Notification Activity

0 Answers   CTS,

---

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---

how do u reduce warnings

1 Answers   CGI,

---

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

---