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
Distinguish between informatica & datastage. Which one would you choose and why?
What are routines in datastage? Enlist various types of routines.
What is usage analysis in datastage?
Is possible to create skid in dim,fact tables?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How do you reject records in a transformer?
Can you explain link buffering?
What is the difference between an operational datastage and a data warehouse?
Can we use target hash file as a lookup ?
What is difference between symmetric multiprocessing and massive parallel processing?
What is size of a transaction and an array means in a datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
EXPLAIN SCD
If you want to use a same piece of code in different jobs, how will you achieve this?
Define ds designer?