Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Is the value of staging variable stored temporarily or permanently?
How many Key we can define in remove duplicate stage?
what is the use of skid in reporting?
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 ?
How and where you used hash file?
What is a datastage job?
Differentiate between validated and Compiled in the Datastage?
What is the process of killing a job in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How to reverse the string using unix?
How to reverse the string using SQL?
On which Dimension Table you implemented SCD Type in your Project
Have you have ever worked in unix environment and why it is useful in datastage?
How can you write parallel routines in datastage PX?
how do u catch bad rows from OCI stage? And what CLI stands for?
