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.

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

---

Define meta stage?

0 Answers  

---

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?

2 Answers  

---

What are the types of jobs we have in datastage?

0 Answers  

---

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

---

Name the different sorting methods in datastage.

0 Answers  

---

How to RD using transformer?

0 Answers   CTS,

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

How do you start developing a datastage project?

0 Answers  

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

Define data aggregation?

0 Answers  

---