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
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Define Merge?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is quality stage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How do you remove duplicate values in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Define Routines and their types?
What is the difference between server job and parallel jobs?
Explain datastage architecture?
What are transforms and what is the differenece between routines and transforms?
What are some prerequisites for datastage?
project Steps,hits, Project level HArd things,Solved methods?
What is datastage?