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.

Main Function of the Staging area in DWH ?

2 Answers  

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

---

What is mapping?

3 Answers  

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

Define Job control?

0 Answers  

---

which memory is used by lookup and join

5 Answers   IBM,

---

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

2 Answers   Cap Gemini,

---

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

---

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

2 Answers   Satyam,

---

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,

---