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.

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

Enlist various types of routines in datastage.

0 Answers  

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

what is the main difference between sorragate key n primary key in one word

2 Answers  

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  

---

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

---

Can you explain repository tables in datastage?

0 Answers  

---

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,

---

count number of deptno in a emp table?

2 Answers   IBM,

---

Explain how a source file is populated?

0 Answers  

---