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 oci?

0 Answers  

---

What is the difference between datastage and datastage tx?

0 Answers  

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

What is the difference between odbc and drs stage?

0 Answers  

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

---

What is the importance of the exception activity in datastage?

0 Answers  

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

How you can fix the truncated data error in datastage?

0 Answers  

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---

What are the different plug-ins stages used in your projects?

0 Answers  

---

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

---

What are the prerequisites for join stage

2 Answers  

---